List:General Discussion« Previous MessageNext Message »
From:Matthew Phillips Date:February 28 2011 12:04pm
Subject:MySQL when running on LiveDVD (GnackTrack - ubuntu based distro) -
Error 2002
View as plain text  
The following occurs when running the Live version of GnackTrack, if you
install from the LiveDVD this issue is no longer present.
LiveDVD can be downloaded from www.gnacktrack.co.uk - this can be used to
demonstrate issue but i think it's likely somethign simple

root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
root@root:~# updatedb
root@root:~# locate mysqld.sock
/rofs/var/run/mysqld/mysqld.sock
root@root:~#

Snip of /etc/mysql/my.cnf (shortened to show sock location.)
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking

Are there any work arounds for this? What could i do to ensure that mysql
can be connected to when running the LiveDVD?


more output:
root@root:~# mysql -h127.0.0.1
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
root@root:~# mysql -S /rofs/var/run/mysqld/mysqld.sock
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/rofs/var/run/mysqld/mysqld.sock' (111)
root@root:~#

Thread
MySQL when running on LiveDVD (GnackTrack - ubuntu based distro) -Error 2002Matthew Phillips28 Feb