临邑生蚝吧 發表於 2019-7-8 23:28:00

Centos 安装mysql

<p><span style="font-size: 14pt"><strong>1.下载mysql</strong></span></p>
<div class="cnblogs_code">
<pre>wget -i -c https:<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">repo.mysql.com</span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">mysql80-community-release-el7-3.noarch.rpm</span></pre>
</div>
<p>&nbsp; 使用上面的命令就直接下载了安装用的Yum Repository，大概25KB的样子，然后就可以直接yum安装了。</p>
<div class="cnblogs_code">
<pre>yum -y install mysql80-community-release-el7-3.noarch.rpm</pre>
</div>
<p>之后就开始安装MySQL服务器。</p>
<div class="cnblogs_code">
<pre>yum -y install mysql-community-server</pre>
</div>
<p>这步可能会花些时间，安装完成后就会覆盖掉之前的mariadb。</p>
<p>&nbsp;</p>
<h3>2 MySQL数据库设置</h3>
<p>启动mysql</p>
<div class="cnblogs_code">
<pre>systemctl startmysqld.service</pre>
</div>
<p>查看运行状态</p>
<div class="cnblogs_code">
<pre>systemctl status mysqld.service</pre>
</div>
<p><img src="https://img2018.cnblogs.com/blog/1735716/201907/1735716-20190708232252988-726710168.png"></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>此时MySQL已经开始正常运行，不过要想进入MySQL还得先找出此时root用户的密码，通过如下命令可以在日志文件中找出密码：</p>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre>grep <span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">password</span><span style="color: rgba(128, 0, 0, 1)">"</span> /<span style="color: rgba(0, 0, 255, 1)">var</span>/log/mysqld.log</pre>
</div>
<p><img src="https://img2018.cnblogs.com/blog/1735716/201907/1735716-20190708232336766-753330848.png"></p>
<p>&nbsp;</p>
<p>进入数据库</p>
<div class="cnblogs_code">
<pre>mysql -uroot -p</pre>
</div>
<p>&nbsp; 输入初始密码，此时不能做任何事情，因为MySQL默认必须修改密码之后才能操作数据库：</p>
<div class="cnblogs_code">
<pre>ALTER USER <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span>@<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">localhost</span><span style="color: rgba(128, 0, 0, 1)">'</span> IDENTIFIED BY <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">新密码</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</pre>
</div>
<p>&nbsp;这里有个问题，新密码设置的时候如果设置的过于简单会报错：</p>
<p>&nbsp;原因是因为MySQL有密码设置的规范，具体是与validate_password_policy的值有关：</p>
<p>&nbsp;</p>
<p>MySQL完整的初始密码规则查看</p>
<div class="cnblogs_code">
<pre>SHOW VARIABLES LIKE <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">validate_password%</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</pre>
</div>
<p>初始情况下第一个的值是ON，validate_password_length是8。可以通过如下命令修改：</p>
<div class="cnblogs_code">
<pre>mysql&gt; <span style="color: rgba(0, 0, 255, 1)">set</span> <span style="color: rgba(0, 0, 255, 1)">global</span> validate_password.policy=<span style="color: rgba(128, 0, 128, 1)">0</span><span style="color: rgba(0, 0, 0, 1)">;
mysql</span>&gt; <span style="color: rgba(0, 0, 255, 1)">set</span> <span style="color: rgba(0, 0, 255, 1)">global</span> validate_password.length=<span style="color: rgba(128, 0, 128, 1)">1</span>;</pre>
</div>
<p>&nbsp;设置之后就是我上面查出来的那几个值了，此时密码就可以设置的很简单，例如1234之类的。到此数据库的密码设置就完成了。</p>
<p>&nbsp; 但此时还有一个问题，就是因为安装了Yum Repository，以后每次yum操作都会自动更新，需要把这个卸载掉：</p>
<div class="cnblogs_code">
<pre>yum -y remove mysql57-community-release-el7-<span style="color: rgba(128, 0, 128, 1)">10</span>.noarch</pre>
</div>
<p>&nbsp;</p><br><br>
来源：https://www.cnblogs.com/funbin/p/11154784.html
頁: [1]
查看完整版本: Centos 安装mysql