你自己再检查一下这里吧:
“同时增加了用户backup,密码1234”
和
“master-user=backup#同步数据库的用户
master-password=backup#同步数据库的密码”<--------这里的密码应该是"123"吧
“同时增加了用户backup,密码1234”
和
“master-user=backup#同步数据库的用户
master-password=backup#同步数据库的密码”<--------这里的密码应该是"123"吧
master-password=1234#同步数据库的密码”账号是正确的,但是日志就是显示,While trying to obtain the list of slaves from the master '192.168.1.4:3306', user 'bakcup' got the following error: 'Access denied. You need the REPLICATION SLAVE privilege for this operation'
-> TO 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass';If you plan to use the LOAD TABLE FROM MASTER or LOAD DATA FROM MASTER statements from the slave host, you must grant this account additional privileges: Grant the account the SUPER and RELOAD global privileges. Grant the SELECT privilege for all tables that you want to load. Any master tables from which the account cannot SELECT will be ignored by LOAD DATA FROM MASTER.