MySQL Troubleshoot

After the Linux server restarts, it is found that Mysql cannot start
Failure 1: Start failure
Error message: Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock'

solution:

1: Try to restart the mysql server, whether the same error occurs

2: If the same error occurs, restart after deleting the mysql.sock file

rm -rf /usr/local/mysql/mysql.sock

systemclt restart mysqld

Failure 2: Start failure
Error prompt: When starting mysql: Error MySQL Daemon failed to start. 【Failed】

solution:

1: Check the permission setting of the data directory

2: Set the owner and group of the Mysql data directory to be correct,

chown -R mysql:mysql /usr/local/mysql

Failure 3: Remote connection failure
Error message:

When using mysql -u root -h database IP -p to name the remote connection Mysql, a prompt appears:

Enter password:

ERROR 2003 (HYOOO): Can't connect to MySQL server on ‘xxx’ (113)

solution:

1: Check the network to ensure that the network is properly connected

2: Authorize the root account

GRANT all ON *.* TO'root'@'IP address' IDENTIFIED BY '123456';

3: Turn off the firewall

Fault four: master-slave fault
Error prompt: An error occurs when restarting from the server:

Master_SSL_Verify_Server_Cert:No

Last_IO_Errno:1593

Last_IO_Error:fatal error: The slave I/O thread stops because master and slave have equal mysql server ids

solution:

Modify service_id from mysql to other values