Skip navigation links

MySQL Forums :: Install & Repo :: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


Advanced Search

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
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

Options: ReplyQuote


Subject Written By Posted
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Tim Vantag 03/07/2007 02:41AM
Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Colin Charles 03/13/2007 05:10AM
Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) dickje wigje 03/14/2007 07:06PM
Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) N S 03/23/2007 02:50AM
Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) dickje wigje 03/23/2007 06:31PM
Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) david freer 04/07/2007 11:45PM


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.