Lost connection to MySQL server at ' reading initial communication packet error resolution

Today, the online MySQL error, not even on the error message is roughly Lost connection to the MySQL server at ' reading initial communication packet. and then on the Internet to find some solutions, a one here to explain, convenient later in the encounter such problems do not know how to solve:

Finally found the reason is/var/lib/mysql/below the mysql.sock disappeared, why not found, the following is the solution:

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

1. Check the/ETC/RC.D/INIT.D/MYSQLD status first to see if the MySQL service has been started.
Also see if it is a permission issue.
$service mysqld Start
Or
$service MySQL Start
I started to encounter is because the service did not start, because the first time to play MySQL is not very familiar with, hehe.

2. Determine if your mysql.sock is in that position,
Mysql-u your MySQL user name-p-s/var/lib/mysql/mysql.sock

3, if it is a permission problem, change the permissions first #chown-R mysql:mysql/var/lib/mysql

[[email protected] ~]#/etc/init.d/mysqld start
Start MySQL: [OK]
[Email protected] ~]# mysql-uroot-p

ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)
The reason for this is that the/var/lib/mysql access rights issue.

Shell> Chown-r Mysql:mysql/var/lib/mysql

Then start the server

Shell>/etc/init.d/mysql Start

After the server starts normally, look/var/lib/mysql automatically generate Mysql.sock files.

4, modify/etc/my.conf:
[Mysqld]
Datadir=/usr/local/mysql/data
Socket=/var/lib/mysql/mysql.sock

[Mysql.server]
User=mysql
Basedir=/usr/local/mysql

If There is not currently a section called [Client], add one at the bottom of the file and copy the socket= line under the [MYSQLD] section such as:

[Client]
Socket=/var/lib/mysql/mysql.sock

If you find the problem is still, try running/etc/init.d/mysql start error: Starting mysqlcouldn ' t find MySQL manager or server

Lost connection to MySQL server at ' reading initial communication packet error resolution