mysql.socket location problem

Hi
I just did a new installation of Suse 11.2 and found that I couldn't
connect to mysql from a php script because mysql.sock was
in /var/run/mysql/mysql.sock rather than /var/lib/mysql/mysql.sock. I
changed all the lines in /etc/my.cnf for the socket
to /var/lib/mysql/mysql.sock. Now my php scripts connect but I can't
connect to mysql from the command line. I get the error can't connect
through socket /var/run/mysql/mysql.sock. What do I have to change to
make the konsole use /var/lib/mysql/mysql.sock?

Thanks,
Scott


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: mysql.socket location problem

Hi Scott,

Change socket =3D in the [client] section of your my.cnf as well.

Regards
Gavin Towey

-----Original Message-----
From: Scott Wagner [mailto:gildedpage@comcast.net]
Sent: Monday, October 05, 2009 3:21 PM
To: mysql@lists.mysql.com
Subject: mysql.socket location problem

Hi
I just did a new installation of Suse 11.2 and found that I couldn't
connect to mysql from a php script because mysql.sock was
in /var/run/mysql/mysql.sock rather than /var/lib/mysql/mysql.sock. I
changed all the lines in /etc/my.cnf for the socket
to /var/lib/mysql/mysql.sock. Now my php scripts connect but I can't
connect to mysql from the command line. I get the error can't connect
through socket /var/run/mysql/mysql.sock. What do I have to change to
make the konsole use /var/lib/mysql/mysql.sock?

Thanks,
Scott


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg