Mysql routine problem records

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