環境：CentOS7、MySQL-5.7.17

1、軟件下載

在MySQL官網下載mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar

2、解壓

tar -xvf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar

mkdir mysql

mv mysql-community*.rpm mysql

3、卸載mariadb

rpm -qa | grep mariadb

rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

4、安裝MySQL

rpm -ivh mysql-community-common-5.7.17-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.17-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm

5、設置密碼

vi /etc/my.cnf

[mysqld]之后添加skip-grant-tables

service mysqld start

mysql -uroot

>update mysql.user set authentication_string=passWord('123456') where user='root' ;

>flush PRivileges;

>exit;

service mysqld stop

vi /etc/my.cnf

刪除skip-grant-tables

service mysqld start

mysql -uroot -p123456

>set global validate_password_policy=0;

>set global validate_password_length=1;

>set global validate_password_mixed_case_count=2;

>set password = password('123456');

>exit;

6、開啟遠程登錄

mysql -uroot -p123456

>GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION; 

>FLUSH PRIVILEGES;