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
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:
No on the scripts, yes on phpmyadmin... It seems to be a permissions problem for this particular user that is not allowing them to connect. Can anyone tell me where I would look to find out for sure? /var/lib/mysql permissions and ownership look right, is there anywhere else I should be checking?