List:General Discussion« Previous MessageNext Message »
From:Tom Brown Date:August 31 2006 7:59am
Subject:CentOS 4.3 - MySQL - NIS user issue
View as plain text  
Hi

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.

mysql>

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 
'/var/lib/mysql/mysql.sock' (13)

any ideas why this is or what i can do to make it work?

thanks
Thread
CentOS 4.3 - MySQL - NIS user issueTom Brown31 Aug
  • Re: CentOS 4.3 - MySQL - NIS user issueDan Nelson31 Aug
  • Re: CentOS 4.3 - MySQL - NIS user issueWai-Sun Chia4 Sep