MySQL5.7安装说明

MySQL5.6 yum卸载

1.查看已安装的mysql
     命令：rpm -qa | grep -i mysql
2.卸载mysql
     命令：yum remove mysql-community-server-5.6.36-2.el7.x86_64

MySQL5.7 yum安装

1.安装mysql57-community-release-el7-11.noarch.rpm包

 rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2. 安装5.7包

yum --enablerepo=mysql57-community install mysql-community-server

3.启动mysql服务

 service mysqld restart

4.修改配置

 vim /etc/my.cnf

在[mysqld]的最后添加

skip-grant-tables跳过密码验证

5.重启数据库

service mysqld restart

6.登录数据库修改root权限

update mysql.user set authentication_string=password('root') where user='root';

flush privileges;

7.改回配置

vim /etc/my.cnf

在[mysqld]的最后去掉

skip-grant-tables跳过密码验证

8.重启数据库

service mysqld restart

9.工具连接测试