Home > database >  Mysql5.7.22 master-slave unable to connect
Mysql5.7.22 master-slave unable to connect

Time:09-26

Alone with mysql -u -p - h - p this command, can be in from the machine connected to the host, I use the gtid pattern, but start slave, tip error in log 2003 mistakes, don't know what is going on, please inform me to have a friend know, thank you

CodePudding user response:

Restart the slave

CodePudding user response:

Which part should be configuration has a problem, too little information
Change master to master_host=masterip ', '
Master_user=repl ', '
Master_password=replpwd ', '
Master_log_file='log file of the master,'
Master_log_pos=pos;

CodePudding user response:

reference crynono reply: 3/f
which part should be configuration has a problem, too little information
Change master to master_host=masterip ', '
Master_user=repl ', '
Master_password=replpwd ', '
Master_log_file='log file of the master,'
Master_log_pos=pos;



CHANGE the MASTER TO MASTER_HOST='* * * *,
MASTER_PORT=* * *,
MASTER_USER='* * * *,
MASTER_PASSWORD='* * * *,
MASTER_AUTO_POSITION=1;

Because I use the gtid mode of replication

CodePudding user response:

Check whether the mysql process start
Look at the duplicate account authorized by the IP
Reset slave; Reset the master; Change again after the master to

All the log stick out
  • Related