1.mysql5.6安裝

wget?http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum install mysql-community-server

service mysqld restart

service mysqld status

netstat -antup|grep 3306

mysql -u root

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "xxxxx@mysql56";

flush privileges;

2.yum安裝5.7版mysql

?wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

? yum localinstall mysql57-community-release-el7-11.noarch.rpm

? yum install mysql-community-server

systemctl start mysqld

cat /var/log/mysqld.log 查看初始密碼

登錄mysql

mysql -uroot -p

修改root密碼

SET PASSWORD = PASSWORD('XXxxx@2017'); # mysql7密碼設(shè)置有復(fù)雜度要求

flush privileges;

3.mysql8安裝

安裝：

wget -c https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

rpm -ivh mysql80-community-release-el7-1.noarch.rpm

yum clear all

yum makecache

yum repolist all | grep mysql

yum install mysql-community-server

cat /var/log/mysqld.log | grep password

啟動(dòng)配置：

service mysqld restart

mysql -u root -p

set password="XXxx@2018";

ALTER USER "root"@"localhost" IDENTIFIED??BY "XXxxx@mysql8";

CREATE USER 'xxbmm'@'%' IDENTIFIED BY 'XXxxx@mysql8';

grant all on *.* to 'xxxxx'@'%';

ALTER USER 'xxxxx'@'%' IDENTIFIED WITH mysql_native_password BY 'XXxxx@mysql8';