MySQL problem, please help me!
Please help me to fix this problem.
I could not add user and create Databasic in CPanel.
I logged into WHM, and check MySQL status, it was failed.
I click on ¡§Change a User or Database Password ¡§, I got this message:
¡§ ERROR 2002: Can¡¦t connect to local MySQL through socket ¡¥/var/lib/mysql.sock¡¦(2) ¡§
Then I logged into SSH and check file ¡§ mysql.sock ¡§, but file ¡§ /var/lib/mysq.sock ¡§ is not there. Then I logged into WHM again, I click on PhpMyAdmin, I got this message:
¡§Wrong username/password. Access denied. ¡§
This is my file ¡§ /etc/my.cnf ¡§
-----------------------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-----------------------------------------------------
Could some one tell me how to fix this ?
Thank you so much !
Web4fun
