I'm having trouble connecting to the mysql database, MySQL Administrator is giving an error about not being able to find the socket. "Could not connect to host 'localhost'. MySQL Error Nr. 2002 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)" When I use the Ping Host button it does find the host. Mike@P-733-Lin:~> rpm -q mysql mysql-5.0.67-12.11 Mike@P-733-Lin:/var/lib/mysql> ls -l total 21227 -rw-rw---- 1 mysql mysql 10485760 2009-05-16 13:44 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2009-05-16 13:44 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2009-05-16 13:09 ib_logfile1 drwx------ 2 mysql mysql 2352 2009-05-16 13:09 mysql -rw-rw---- 1 mysql mysql 19855 2009-05-16 13:09 mysql-bin.000001 -rw-rw---- 1 mysql mysql 709496 2009-05-16 13:09 mysql-bin.000002 -rw-rw---- 1 mysql mysql 925 2009-05-16 13:44 mysql-bin.000003 -rw-rw---- 1 mysql mysql 57 2009-05-16 13:09 mysql-bin.index -rw-r--r-- 1 root root 0 2009-05-16 16:41 mysqld.pid drwx------ 2 mysql mysql 72 2009-05-16 13:35 mythconverg drwx------ 2 mysql mysql 48 2009-05-16 13:09 test I see the .pid file but not the socket file. Mike@P-733-Lin:~> ls /var/run/mysql Mike@P-733-Lin:~> From /etc/my.cnf: # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock #socket = /varacer laptop hard drive replace howto/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock # Change following line if you want to store your database elsewhere datadir = /var/lib/mysql skip-locking From /etc/init.d/mysql: # The following section has been taken from # the original MySQL init script # Note: If you want to change these variables, you'll make your life easier # if you do so in /etc/my.cnf, which is preserved during upgrades basedir=/usr datadir=/var/lib/mysql mysql_daemon_user=mysql mysql_daemon_group=mysql pid_file=/var/lib/mysql/mysqld.pid socket=/var/lib/mysql/mysql.sock print_defaults=/usr/bin/my_print_defaults Any idea as to how to best troubleshoot and correct this? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org