mysql 8.0.28安装和配置主从中遇到的一些问题总结

 

问题总结

1. mysql 8.0.28 修改root密码
8.0.28有密码复杂度限制：大写+小写+数字+标点符号

2. mysql 8.0.28 修改root远程连接
update user set host = '%' where host = 'localhost' and user = 'root';

3. 修改了root远程连接的host=%之后，重新修改root密码时语句的'root'@'localhost'应该改成'root'@'%'
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'XXXXX';


4. 设置master信息语句
change master to master_host='192.168.XXX.XXX',master_user='XXXX',master_password='XXXXX',master_log_file='XXXXX',master_log_pos=XXXX;

5. mysql 8.0.28安装顺序
 sudo rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm 
 sudo rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm 
 sudo rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm 
 sudo rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm 
 sudo rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm 
 sudo rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm

6. 跳过密码登录mysql8.0.28
mysqld --skip-grant-tables --skip-networking --user=root &

7. 刷新设置
flush privileges;

 查看自己主机是否安装了libaio，没安装的话用yum安装

查询是否安装libaio
# rpm -qa |grep libaio

重载mysql
# mysqld --initialize --console

查找重载密码
# grep 'temporary password' /var/log/mysqld.log