1.删除系统默认安装的Mysql
for i in $(rpm -qa|grep mysql);do rpm -e $i --nodeps;done
rm -rf /var/lib/mysql && rm -rf /etc/my.cnf
2.安装Mysql8.0 的yum资源库
yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
3.安装mysql
yum install mysql-community-server
service start mysqld
service enable mysqld
4.显示初始密码
可使用初始密码登录
grep 'temporary password' /var/log/mysqld.log
5.登录并修改密码
mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_11ad';
注意分号,而且由于8.0版本原因需要修改简单的密码需要重设权限,然后可以随意设置密码了
修改密码长度:set global validate_password.length=1;(长度)
修改密码等级:set global validate_password.policy=0;(等级)
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
6.设置端口
systemctl start firewalld --开启防火墙
firewall-cmd --permanent --zone=public --add-port=3306/tcp
systemctl status firewalld --查看firewalld状态,显示(Activate)running说明已开启了。
7.配置过程出现了2059错误,解决办法如下
show variables like 'default_authentication_plugin';
select host,user,plugin from mysql.user;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;