CentOS7使用dnf安装mysql的方法
<p>本文介绍了CentOS7使用dnf安装mysql的方法，分享给大家，具体如下：</p><p>
1.安装mysql的yum仓库</p><p>
执行以下命令：</p><p>
</p><div class="codetitle"><span style="text-decoration:underline;">复制代码</span> 代码如下:</div><div class="codebody" id="code60721"><br/>
yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm</div><p><br/></p><p>
2.安装mysql</p><div class="jb51code"><div><div class="syntaxhighlighterbash" id="highlighter_871237"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="bash plain">dnf </code><code class="bash functions">install</code> <code class="bash plain">mysql-community-server</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
3.开启mysql服务</p><div class="jb51code"><div><div class="syntaxhighlightersql" id="highlighter_525860"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql plain">service mysql start</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
4.查找默认密码</p><p>
为了加强安全性，MySQL5.7为root用户随机生成了一个密码，在error log中，关于error log的位置，如果安装的是RPM包，则默认是/var/log/mysqld.log。</p><p>
只有启动过一次mysql才可以查看临时密码，输入以下命令查看密码：</p><div class="jb51code"><div><div class="syntaxhighlightersql" id="highlighter_841921"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql plain">grep </code><code class="sql string">'temporary password'</code> <code class="sql plain">/var/log/mysqld.log</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
输出如下：</p><blockquote><p>
# grep 'temporary password' /var/log/mysqld.log <br/>
2018-03-09T13:03:32.859149Z 1 A temporary password is generated for root@localhost: IVXhn:4E3uQ4</p></blockquote><p>
5.登陆mysql并且修改密码</p><div class="jb51code"><div><div class="syntaxhighlightersql" id="highlighter_788608"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">ALTER</code> <code class="sql color2">USER</code> <code class="sql string">'root'</code><code class="sql plain">@</code><code class="sql string">'localhost'</code> <code class="sql plain">IDENTIFIED </code><code class="sql keyword">BY</code> <code class="sql string">'root123'</code><code class="sql plain">;</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
修改密码，会出现：</p><blockquote><p>
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements</p></blockquote><p>
必须修改两个全局参数：</p><p>
首先，修改validate_password_policy参数的值</p><div class="jb51code"><div><div class="syntaxhighlightersql" id="highlighter_959954"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">set</code> <code class="sql keyword">global</code> <code class="sql plain">validate_password_policy=0;</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
再修改密码的长度</p><div class="jb51code"><div><div class="syntaxhighlightersql" id="highlighter_998537"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">set</code> <code class="sql keyword">global</code> <code class="sql plain">validate_password_length=1;</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
再次执行修改密码就可以了</p><div class="jb51code"><div><div class="syntaxhighlightersql" id="highlighter_74944"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">ALTER</code> <code class="sql color2">USER</code> <code class="sql string">'root'</code><code class="sql plain">@</code><code class="sql string">'localhost'</code> <code class="sql plain">IDENTIFIED </code><code class="sql keyword">BY</code> <code class="sql string">'root123'</code><code class="sql plain">;</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
6.授权其他机器连接</p><div class="jb51code"><div><div class="syntaxhighlightersql" id="highlighter_350082"><div class="toolbar">?</div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr class="firstRow"><td class="gutter"><div class="line number1 index0 alt2">
1</div><div class="line number2 index1 alt1">
2</div><div class="line number3 index2 alt2">
3</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">GRANT</code> <code class="sql color1">ALL</code> <code class="sql keyword">PRIVILEGES</code> <code class="sql keyword">ON</code> <code class="sql plain">*.* </code><code class="sql keyword">TO</code> <code class="sql string">'root'</code><code class="sql plain">@</code><code class="sql string">'%'</code> <code class="sql plain">IDENTIFIED </code><code class="sql keyword">BY</code> <code class="sql string">'passwort'</code> <code class="sql keyword">WITH</code> <code class="sql keyword">GRANT</code> <code class="sql keyword">OPTION</code><code class="sql plain">; //passwort改为mysql登陆密码</code></div><div class="line number2 index1 alt1">
</div><div class="line number3 index2 alt2"><code class="sql plain">FLUSH </code><code class="sql keyword">PRIVILEGES</code><code class="sql plain">;</code></div></div></td></tr></tbody></table></div></div><div class="codetool" id="codetool"><div class="code_n"></div></div></div><p>
7.密码设置的详细说明</p><p>
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。</p><p>
原文链接：http://www.cnblogs.com/vitasyuan/p/8536983.html</p>
頁:
[1]