Mysql routine problem record _ MySQL

Mysql daily problem record bitsCN.com

1. modify the mysql log path
Vim/etc/my. cnf
Log-bin = mysql-bin
To:
Log-bin =/$ PATH/mysql-bin
After modification, save and exit.
Modify the mysql-bin.index file to modify the path to an existing log.
The default value is./mysql-bin .....
Change to/$ PATH/mysql-bin ....
After replacement, you can restart the mysql service. Otherwise, an error occurs.
2. problem: Error: 'Lost connection to MySQL server at 'Reading initial communication packet ', system error: 113 'errno: 2013 retry-time: 30 retries: 86400
Solution: Add a startup parameter in the [mysqld] section of my. cnf.
Skip-name-resolve
Save and restart. The skip-name-resolve option can disable dns resolution.
3. problem: Error reading packet from server: Access denied; you need the replication slave privilege for this operation (server_errno = 1227)
Solution: The master server does not have enough replication permissions and the master server re-grants permissions.
Grant replication slave on *. * to 'replicase' @ 'IP address' identified by 'password ';
Flush privileges;
Remote retest is normal.
..
This article is from the "My O & M path" blog

BitsCN.com