云服务器 CentOS 7.2 安装 MySQL 5.7.26

深藏阁楼爱情的钟 2021-12-19 03:34 167阅读 0赞

1. 下载mysql的yum源

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;"># cd /usr/local/</p> <p style="margin-left:0in;"># wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm</p> </td> 
  </tr> 
 </tbody> 
</table>

2. 安装mysql的yum源

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;"># rpm -ivh mysql57-community-release-el7-11.noarch.rpm</p> </td> 
  </tr> 
 </tbody> 
</table>

3. 查看当前启用的mysql版本

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;"><span style="color:#24292e;"># yum repolist enabled | grep mysql</span></p> </td> 
  </tr> 
 </tbody> 
</table>

4. 安装mysql

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;"># yum install mysql-community-server</p> <p style="margin-left:0in;">碰到选择，使用y即可</p> </td> 
  </tr> 
 </tbody> 
</table>

5. 修改默认字符集

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;"># vi /etc/my.cnf</p> <p style="margin-left:0in;">在[mysqld]新增</p> <p style="margin-left:0in;">character_set_server = utf8</p> </td> 
  </tr> 
 </tbody> 
</table>

6. 启动mysql

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;"><span style="color:#24292e;"># systemctl start mysqld</span></p> </td> 
  </tr> 
 </tbody> 
</table>

7. 修改root密码

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;"><span style="color:#24292e;"># </span><span style="color:#24292e;">查看默认的密码</span></p> <p style="margin-left:0in;"><span style="color:#24292e;">grep 'temporary password' /var/log/mysqld.log</span></p> <p style="margin-left:0in;"><span style="color:#24292e;">mysql –uroot –p </span><span style="color:#24292e;">上面的密码</span></p> <p style="margin-left:0in;"><span style="color:#24292e;">进入后</span><span style="color:#24292e;">, </span><span style="color:#24292e;">修改密码</span></p> <p style="margin-left:0in;">mysql&gt; set password for 'root'@'localhost'=password('新密码');</p> </td> 
  </tr> 
 </tbody> 
</table>

8. 创建用户及授权

<table style="margin-left:.25in;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:414.8pt;"> <p style="margin-left:0in;">创建普通用户</p> <p style="margin-left:0in;">mysql&gt; create user '普通用户'@'%' IDENTIFIED BY '密码';</p> <p style="margin-left:0in;">授权</p> <p style="margin-left:0in;">mysql&gt; GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 普通用户@"%";</p> <p style="margin-left:0in;">&nbsp;</p> <p style="margin-left:0in;">创建管理员用户</p> <p style="margin-left:0in;">mysql&gt; CREATE USER 'admin'@'%' IDENTIFIED BY '密码';</p> <p style="margin-left:0in;">授权</p> <p style="margin-left:0in;">mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%';</p> <p style="margin-left:0in;">&nbsp;</p> <p style="margin-left:0in;">使权限生效</p> <p style="margin-left:0in;">mysql&gt; flush privileges;</p> </td> 
  </tr> 
 </tbody> 
</table>

更多内容，参见： [https://yq.aliyun.com/articles/654980][https_yq.aliyun.com_articles_654980]

[https_yq.aliyun.com_articles_654980]: https://yq.aliyun.com/articles/654980