[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 19/06/06, Neil Winchurst <neil@xxxxxxxxxxxxxxxxx> wrote: > I have had a search and there doesn't appear to be any such file on my > computer. The socket file does not appear to be present anywhere either. > > In /usr/share/mysql I do have the following > > my-large.cnf > my-huge.cnf > my-medium.cnf > my-small.cnf > my-innodb-heave-4G.cnf > > but no plain my.cnf > > Is this my problem? Quite possibly. The server will be using one of them, but the client is obviously not.. You could check which one the server is currently using from the command line... ps aux | grep mysql root 1633 0.0 0.0 4248 240 ? S Jun11 0:00 /bin/sh /usr/local/mysql/bin/safe_mysqld mysql 1661 0.0 0.4 127456 1148 ? Sl Jun11 0:05 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/tmp/mysql.sock and then base your my.cnf on that.. in mine I have (amongst other stuff) : [mysql] socket=/tmp/mysql.sock which tells the client (mysql as opposed to mysqld, etc) where to look Cheers, A -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html