Tiger_23的专栏

1，查看root远程登录访问mysql> select host,user from user where user='root';+-----------+------+| host | user |+-----------+------+| % | root || 127.0.0.1 | root || localhost | root |+--...

一，主库执行操作1，备份主库[root@MyCloudServer ~]# mysqldump -uroot -p --set-gtid-purged=OFF --single-transaction --master-data=1 --all-databases > dump.sql2，将备份文件拷贝到从库[root@MyCloudServer ~]# scp -P1022...