MySQL + phpMyAdmin

[xbuzz]

MySQL and phpMyAdmin are not functioning properally. When I select "phpMyAdmin" from "WHM" I recieve the following error message from phpMyAdmin

Wrong username/password. Access denied.

I reset the password and it appears to be correct even in /root/.my.cnf

When I log into the server via shell as root and type "mysql -u root" I get the following error message.

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

Any help would greatly be appreciated!

[linux-image]

on shell as root type:

/etc/rc.d/init.d/mysql restart

then check to see if there are any errors specified.

[madaboutlinux]

Set the permissions of /tmp directory to 1777 and also check whether the mysql.sock is present in the /tmp, if not, do the following :-
chmod 1777 /tmp
ln -s /var/lib/mysql/mysql.sock /tmp
service mysql restart

If the above doesn't fix the issue, execute the below script :-
/scripts/mysqlup --force

[xbuzz]

i just ran that script and the problem still exists. additionally i ran "updatedb" and then typed "locate mysql.sock" nothing was found. any ideas???

thanks for the reply

[madaboutlinux]

Try adding the below lines in /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
[client]
socket=/tmp/mysql.sock

and restart Mysql as given by :-
/etc/rc.d/init.d/mysql restart

Else paste the output of the below command :-
/var/lib/mysql/bin/mysqld_safe &
or
/usr/bin/mysqld_safe &

[madaboutlinux]

Check the post of "Murtaza_t" in the below thread, that should definetly help you out.

http://forums.cpanel.net/showthread.php?t=47313