An error is reported when implementing MySQL master-slave replication configuration, as shown in the figure:
Reason: it is not allowed to change when starting MySQL master-slave replication
Solution: first turn off MySQL master-slave replication, then refresh, then make changes, and then turn on MySQL master-slave replication
① turn off MySQL master-slave replication
stop slave;
② Refresh
flush privileges;
③ Enable MySQL master-slave replication
start slave;
Read More:
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- [Solved] MYSQL Error: unknown error 1130, unknown error 1045
- Error 1418 (HY000): this function has none of deterministic, no SQL
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- [Solved] ERROR 1030 (HY000): Got error 28 from storage engine
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
- Doris reports an error: error 1064 (HY000) [How to Solve]
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- RECEIVED ERROR PACKET: ERRNO = 1236, SQLSTATE = HY000 ERRMSG = COULD NOT FIND FIRST LOG FILE NAME IN BINARY LOG INDEX FILE
- [Solved] ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘