I have what i think is a strange issue -
All my users are NIS users and they can access this box fine. I have a
MySQL server running on this box that is running fine. The OS 'root'
user can authenticate and use MySQL fine as this is not a NIS user e.g.
[root@xxxxxxx]# mysql -u bugs -pxxxx bugs
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Yes i know thats an ancient MySQL version but this is an app
requirement, dont get me started!
now when a NIS user tries to use the db
[root@xxxx]# su - bugzilla
bugzilla@xxxx$ mysql -u bugs -pxxxx bugs
ERROR 2002: Can't connect to local MySQL server through socket
any ideas why this is or what i can do to make it work?