Error message:
Error 2002 (hy000): Can't connect to local MySQL server through socket '/var/lib/MySQL. Sock' (2)
1. Check/etc/rc. d/init. d/mysqld status to see if m y s q l has been started.
Check whether the permission is correct.
2. Check whether your MySQL. Sock is in that location,
Mysql-u your MySQL username-p-S/var/lib/MySQL. Sock
3. Try: Service mysqld start (start MySQL Service)
4. If the permission problem occurs, change the permission first # chown-r MYSQL: MySQL/var/lib/MySQL
[Root @ localhost ~] #/Etc/init. d/mysqld start
Start MYSQL: [OK]
[Root @ localhost ~] # Mysql-uroot-P
Error 2002 (hy000): Can't connect to local MySQL server through socket '/var/lib/MySQL. Sock' (2)
The reason is that the access permission of/var/lib/MySQL is incorrect.
Shell> chown-r MYSQL: MySQL/var/lib/MySQL
Start the server.
Shell>/etc/init. d/MySQL start
After the server is started normally, check/var/lib/MySQL to automatically generate the mysql. Sock file.
However, my problem is still not solved.
The problem is finally solved:
Method: Modify/etc/My. conf:
[Mysqld]
Datadir =/usr/local/MySQL/Data
Socket =/var/lib/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:
[Client]
Socket =/var/lib/MySQL. Sock
The error "Starting mysqlcouldn't find MySQL manager or server" is returned when you run/etc/init. d/MySQL start.
If the mysqld service is not enabled, run/usr/local/MySQL/bin/mysqld_safe &
Solve the problem.