centos安装mysql5.7

文中图片均为成功样例，遇到如下图情况通通输入y再回车

1、下载mysql源安装包

 wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

2、安装mysql源

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

3、检查mysql源是否安装成功

yum repolist all | grep mysql

4、禁用8.0，启用5.7

sudo yum-config-manager --disable mysql80-community

sudo yum-config-manager --enable mysql57-community

5、确认是否执行成功

yum repolist enabled | grep mysql

6、安装MySQL

yum install mysql-community-server --nogpgcheck

7、启动MySQL服务

systemctl start mysqld

8、查看状态

systemctl status mysqld

9、设置开机启动

systemctl enable mysqld

systemctl daemon-reload

10、修改密码

• 查看初始密码

sudo grep 'temporary password' /var/log/mysqld.log

• 登录

mysql -uroot -p
#回车后输入密码（复制刚刚的初始密码）

• 修改密码策略

set global validate_password_policy=0;

set global validate_password_length=1;

• 更改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '你想设置的密码'; 

• 设置允许远程登录及密码，比如navicat，该密码与上面这个密码可不相同

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你想设置的密码' WITH GRANT OPTION;

11、退出mysql

exit

12、修改默认编码为utf8

• 修改/etc/my.cnf配置文件

vi /etc/my.cnf

• 将如下代码添加至该文件中并保存退出

[mysql]
default-character-set=utf8

[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8

13、重启mysql

systemctl restart mysqld

over