Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hello all, I'm facing the same problem with mysql-5.0.37-linux-i686-glibc23.
Starting mysql seems to be no problem:
maya:/usr/local# /etc/init.d/mysqld start
Starting mysqld
maya:/usr/local# Starting mysqld daemon with databases from /usr/local/mysql/data
maya:/usr/local#
mysql always worked fine for me, but after upgrading from 5.0.27 to 5.0.37 suddenly the mysql.sock is not found. With 5.0.27 and before this was never an issue, so this rules out permission problems.
maya:/# ls -al /tmp | grep mysql
maya:/#
No socket found!
Also the possibility of another location for the socket can be outruled:
maya:/# updatedb
maya:/# locate mysql.sock
maya:/#
doesn't return anything, and
maya:/# find / -type s
/dev/log
find: /proc/19822/fd/4: No such file or directory
maya:/#
doesn't return mysql socket either.
maya:/# nmap localhost
Starting nmap 3.81 (
http://www.insecure.org/nmap/ ) at 2007-03-15 02:03 CET
Interesting ports on localhost.lan (127.0.0.1):
(The 1661 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
80/tcp open http
Nmap finished: 1 IP address (1 host up) scanned in 0.235 seconds
maya:/#
doesn't return mysql running on tcp/ip either.
maya:/usr/local# ps aux | grep mysql
root 19834 0.0 0.1 2304 1108 pts/0 S 01:58 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql
mysql 19856 0.2 1.1 36772 11972 pts/0 S 01:58 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/maya.pid --skip-external-locking
root 19857 0.0 1.1 36772 11972 pts/0 S 01:58 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/maya.pid --skip-external-locking
root 19859 0.0 1.1 36772 11972 pts/0 S 01:58 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/maya.pid --skip-external-locking
root 19860 0.0 1.1 36772 11972 pts/0 S 01:58 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/maya.pid --skip-external-locking
root 19861 0.0 1.1 36772 11972 pts/0 S 01:58 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/maya.pid --skip-external-locking
root 19862 0.0 1.1 36772 11972 pts/0 S 01:58 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/maya.pid --skip-external-locking
My hostname.err is only telling me:
070315 01:42:51 mysqld started
070315 01:43:01 mysqld ended
This is really frustrating, because i would like to run the latest version of mysql.
I'm running kernel 2.4.34.1 on Linux Debian 3.1 (stable).
Thanks in advance & kind regards,
Dick