mysql.sock error
Encountered a problem that I'm a bit stuck on, was hoping someone could help. One user is reporting problems being able to access his databases via mysql... He's receiving this error when trying a mysql -u USER -pPASSWORD USER_DBNAME
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
ysql.sock' (2)
The strange thing is that I can connect to the database as root, just not when I'm su'd to this user. Also I can su to another user and connect to that user's database, so I believe this problem is isolated to this account.
I checked permissions and ownership in /var/lib/mysql and it appears to be the same as everything else, and tried a /scripts/fixmysql to no avail. Also, mysql is definitely running.
/var/lib/mysql/host.name.com.err doesn't show any errors when trying to restart:
050802 8:33:13 /usr/sbin/mysqld: Normal shutdown
050802 8:33:13 /usr/sbin/mysqld: Shutdown Complete
050802 08:33:13 mysqld ended
050802 08:33:14 mysqld started
/usr/sbin/mysqld: ready for connections
Any suggestions you might be able to provide would be greatly appreciated!
