How to deal with mysql login error

This article mainly introduces how to deal with mysql login errors, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand how to deal with mysql login errors.

Mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/ tmp/mysql.sock' (2)

Solution:

Less / etc/my.cnf | grep sock

Socket =.

Vi / etc/my.cnf

Socket = / tmp/mysql.sock # add the line

Restart

2.Starting MySQL. ERROR! The server quit without updating PID file (/ data/mysql/localhost.localdomain.pid).

Solution:

Chown-R mysql.mysql / data/

/ etc/init.d/mysqld start

Starting MySQL.. SUCCESS!

After reading the above about how to deal with mysql login errors, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to pay attention to our industry information column.