MySQL Forums
Forum List  »  Install & Repo

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Posted by: dickje wigje
Date: March 14, 2007 07:06PM

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

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

No socket found!

Also the possibility of another location for the socket can be outruled:

maya:/# updatedb
maya:/# locate mysql.sock

doesn't return anything, and

maya:/# find / -type s
find: /proc/19822/fd/4: No such file or directory

doesn't return mysql socket either.

maya:/# nmap localhost

Starting nmap 3.81 ( ) at 2007-03-15 02:03 CET
Interesting ports on localhost.lan (
(The 1661 ports scanned but not shown below are in state: closed)
22/tcp open ssh
80/tcp open http

Nmap finished: 1 IP address (1 host up) scanned in 0.235 seconds

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/ --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/ --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/ --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/ --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/ --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/ --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 on Linux Debian 3.1 (stable).

Thanks in advance & kind regards,


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.