Steve, > Can't connect to local MySQL server through socket '' (111)
> When I type 'mysql -u > ddj -p' on a commandline, I can connect fine. With mysql (the command line tool), you connect on the local host (i.e. server and client are running on the same machine). With MySQLGUI, you seem to do the same; is that right? If so, obviously MySQLGUI tries to use a different socket than mysql. By default, the server will establish a socket as /tmp/mysql.sock. This can be changed by starting the server with --socket=(path), either as a command line option, or in the [mysqld] section of my.cnf (usually /etc/my.cnf). Likewise, you can tell clients which sockets to use. For mysql, this would either be "mysql --socket=(path)" or in the [client] section of my.cnf. If it's configured nowhere, a default value will be used. To find out which socket value is set, connect with mysql and issue: mysql> show variables like '%sock%'; +---------------+---------------------------+ | Variable_name | Value | +---------------+---------------------------+ | socket | /var/lib/mysql/mysql.sock | +---------------+---------------------------+ Then, tell MySQLGUI to use the same socket, and everything should be fine. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
