May 5th, 2000, 05:48 AM
Join Date: May 2000
Time spent in forums: < 1 sec
Reputation Power: 0
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by vcosby:
i have tried the suggested solutions at mysql.com, but am still looking for answer.
as root, i can connect to all databases via sockets and tcpip, but as other users or anonymous, i can only connect to databases vi TCP/IP. this includes the test database.
e.g., when i attempt to connect to the test database:
% mysql test
i receive the error:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
however, i can connect via TCP/IP using:
% mysql -h '127.0.0.1' test
and this is the weird part:
as root i can connect via sockets and TCP/IP, no problem.
any ideas would be greatly appreciated.
Caldera eDesktop Linux 2.4 (2.2.14)
mysql 3.22.32, installed via rpm
skip_networking is OFF
the solution is very simple if you know how to set the sticy bit on mysql socks directory.
Just issue "chmod 1777 dir_where_mysql_sock_file_is" and you go.
At least it worked for me. Next you should (or not) set the privs for mysql.sock file 777.