"Jim Douglas" <[EMAIL PROTECTED]> wrote on 03/13/2006 12:24:56 PM:
> I can connect to mysql with > > mysql -u dbname -p > > When I start MySQL Administrator v 1.1.6 it says > > Could not connect to host 'localhost'. > MySQL Error Nr. 2002 > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) > > ...then I Click on Details and enter, '/var/lib/mysql/mysql.sock' > > And can connect, no problem. > > Doesn't the Administrator look to /etc/my.conf for the socket location info? > > This is my my.conf file > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > > log-error=/var/lib/mysql/mysqlerrorlog > old_passwords=1 > > [mysql.server] > user=mysql > basedir=/var/lib > > [mysqld_safe] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > > > Thanks > > Jim > It may look there but I don't see where you are declaring any settings it wants to pay attention to. You need a new "[mysql]" section with a "socket=" setting in it in order for your clients (like MySQL Administrator) to know where your socket is hiding. [mysql] socket=/var/lib/mysql/mysql.sock [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/lib/mysql/mysqlerrorlog old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid More details are here: http://dev.mysql.com/doc/refman/4.1/en/option-files.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
