"David Inglis" <[EMAIL PROTECTED]> wrote on 11/08/2005 09:33:27 PM:
> I am having the following problem > > with the setting for socket in the my.cnf configuration file set to > socket=/tmp/mysql.sock I am able to connect through a browser but cannot > connect using the mysql client when I change it to > socket=/var/lib/mysql/mysql.sock I can access through mysql client but not > through a browser connection > > How can I fix this any help appreciated. > > > > Regards > > > > David Inglis There is more than one section in the my.cnf file. Make sure you coordinate both the client section and the server section to use the same socket. All clients also have some means of specifying where to look to try to connect to a server. If you tell the server to create a socket file in one place, and your client defaults to looking somewhere else, tell it where to look. Since you didn't say which version you are on, this is a link to the 4.1- docs (but this section is identical for 5.0+) http://dev.mysql.com/doc/refman/4.1/en/program-options.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
