1. 查看是否有已安装的mysql

yum list installed | grep mysql

2. 删除原有的mysql

yum -y remove 第一步查出的程序名称

3. 添加rpm源

去mysql官网(https://dev.mysql.com/downloads/repo/yum/)找到最新的rpm下载链接:

image.png

下载并安装:

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum localinstall mysql-community-release-el6-5.noarch.rpm

4. 查看并只启用mysql57

yum repolist all | grep mysql
yum-config-manager --disable mysql55-community
yum-config-manager --disable mysql56-community
yum-config-manager --enable mysql57-community-dmr

5. 安装mysql

yum install mysql-community-server

6. 启动mysql服务并设置成开机启动

service mysqld start
chkconfig --list | grep mysqld
chkconfig mysqld on

7. 查看自动生成的临时密码

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

8. 使用输出的临时密码登陆mysql

mysql -u root -p

9. 关闭密码复杂性验证

mysql> set global validate_password_policy=0;

10. 设置密码

mysql> set password = password('youpassword');

11. 允许用户远程连接

mysql> grant all privileges on  *.* to 'root'@'%' identified by 'youpassword' with grant option;
mysql> flush privileges;
mysql> exit;