yum CentOS7安装MySQL8.0成功版

mkdir -p /usr/local/mysql再cd /usr/local/mysql
1.wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
2.rpm -vih mysql80-community-release-el7-3.noarch.rpm
3.yum repolist enabled | grep “mysql.-community.”
4.yum install mysql-community-server
5.systemctl start mysqld
6.systemctl status mysqld
7.systemctl enable mysqld
systemctl daemon-reload
8.grep ‘temporary password’ /var/log/mysqld.log
9.mysql -u root -p
10.set global validate_password_policy=0;
11.set global validate_password_length=1;
12.alter user ‘root’@‘localhost’ identified by ’ ‘;
13.show variables like ‘%password%’;
14.use mysql;
15.update user set host=’%’ where user =‘root’;
16.flush privileges;

1-7:安装 8-13：修改密码 14-16：设置远程连接

异常处理：（2058：sqlyog链接异常）
解决方法：
alter user ‘root’@‘localhost’ identified by ‘password’;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;

异常处理： ：ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@‘localhost’
解决方法：
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’;