只是自己做的时候一些简单的记录
mysql端口号:3305
mysql的密码:$mysql -uroot -pmysql123
mysql创建的用户:ltmysql 密码:Ltmysql123!
/tmp/mysql-5.7.36 放MySQL的解压包
双主:
master1:134 master2:135
1.安装好MySQL
2.在master1和master2上创建用户并赋权
master1:
[admin@xhw365 ~]$ mysql -uroot -pmysql123
mysql> create user 'ltmysql'@'%' identified by 'Ltmysql123!';
mysql> grant all on *.* to 'ltmysql'@'%'; 授权 ( 扩展:revoke insert on *.* from'ltmysql'@'10.248.51.*'; 撤销)
mysql> flush privileges;
master2:
[admin@xhw366 ~]$ mysql -uroot -pmysql123
mysql> create user 'ltmysql'@'%' identified by 'Ltmysql123!';
mysql> grant all on *.* to 'ltmysql'@'%';
mysql> flush privileges;
3.配置master