please help: can only connect via mysql.sock as root

i have tried the suggested solutions at mysql.com, but am still looking for answer.

problem:
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.

my environment:
Caldera eDesktop Linux 2.4 (2.2.14)
mysql 3.22.32, installed via rpm
skip_networking is OFF

cheers,
victor

<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.

problem:
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.

my environment:
Caldera eDesktop Linux 2.4 (2.2.14)
mysql 3.22.32, installed via rpm
skip_networking is OFF

cheers,
victor

[/quote]
Hi,
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.
Bye,
Rafal