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 e.g. [root at 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 at xxxx]# su - bugzilla bugzilla at 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
> 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 e.g.oops sorry meant to say all users APART from root are NIS, root is local
> any ideas why this is or what i can do to make it work?Why does the version of mysql that comes with 4.x not work? The compat libs and oldpassword options should allow it to work with 3.x mysql clients just fine. Since you're not using the provided mysql for 4.x, how did you install what you've got? I think at this point you need to provide some more details for what you're doing and how you got there. -- During times of universal deceit, telling the truth becomes a revolutionary act. George Orwell