1.Background of the problem
When creating the MySQL replication link from the node, because the virtual machine is copied from a template, the server ID is the same.
2. Solutions
# edit/etc/my.cnf
vi /etc/my.cnf
# Add the following 2 lines of code
# server-id here, as long as it is not the same, my mysql master node is 1, here I set it to 2
log-bin=mysql-bin
server-id=2
#restart mysql
systemctl restart mysql
Read More:
- [Solved] MYSQL Master-Slave slave I/o for channel, error_code 1045
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] Mysql Build Error: [ERROR] Slave I/O for channel ‘‘: error connecting to master
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- [Solved] Error: ER_HOST_NOT_PRIVILEGED: Host ‘x.x.x.x‘ is not allowed to connect to this MySQL server
- Centos7 Initialize mysql Error: Could not open file ‘/usr/local/mysql/log/mysqld.log‘ for error logging: Per
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- Navicat connected to Mysql error: Client does not support authentication protocol requested by server;