Home Forums Articles Downloads Hosting Freebies Jobs
Welcome to Linux Forums! With a comprehensive Linux Forum, information on various types of Linux software and many Linux Reviews articles, we have all the knowledge you need a click away, or accessible via our knowledgeable members.
Find the answer to your Linux question:
New to Linux Forums? Register here for free!
    Linux Forums > GNU Linux Zone > Servers > mysqld.sock missing
 Servers   Anything server related, Apache, MySQL, Samba, server security, sendmail, exim, etc

Site Navigation
Linux Articles
Linux Forums
Linux Downloads
Linux Hosting
Free Magazines
Job Board
IRC Chat
Linux Forum Topics
Linux Forums
Your Distro
Linux Resources
GNU Linux Zone
The Community
Closed Thread
 
Thread Tools Display Modes
Old 11-09-2006   #1 (permalink)
Linux Engineer
 
Join Date: Sep 2004
Posts: 1,200
mysqld.sock missing
Hi folks,

ubuntu-6.06.1-LAMP-server-amd64

After running;
$ sudo apt-get -install mysql-server mysql-client.

mySQL did not start, complaining "mysqld.sock" missing.

On googling I found following postings;
http://ubuntuforums.org/showthread.php?t=111292
http://ubuntuforums.org/showthread.php?t=140036

$ cat /etc/mysql/my.cnf | grep .sock
Code:
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
socket          = /var/run/mysqld/mysqld.sock
socket          = /var/run/mysqld/mysqld.sock
socket          = /var/run/mysqld/mysqld.sock
It was there.

$ sudo mysqld
Code:
Password:
061109 15:41:52  InnoDB: Started; log sequence number 0 43655
061109 15:41:52 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
061109 15:41:52 [ERROR] Do you already have another mysqld server running on port: 3306 ?
061109 15:41:52 [ERROR] Aborting

061109 15:41:52  InnoDB: Starting shutdown...
061109 15:41:54  InnoDB: Shutdown completed; log sequence number 0 43655
061109 15:41:54 [Note] mysqld: Shutdown complete
$ sudo netstat -tap | grep mysql
Password:
No printout.

I can't figure out a solution. Please help. TIA


B.R.
satimis
satimis is offline  

Old 08-20-2007   #2 (permalink)
Just Joined!
 
Join Date: Sep 2003
Posts: 3
I know this is an old thread but if anybody lands here while looking for a solution try making a symbolic link to /var/run/mysqld/mysqld.sock in /tmp. This will give you /tmp/mysqld.sock, so you will need to change this to mysql.sock. I did# cp -rf mysqld.sock mysql.sock.

Good luck.
Louissypher is offline  
Old 08-21-2007   #3 (permalink)
Just Joined!
 
Join Date: Aug 2007
Location: California
Posts: 2
Send a message via AIM to giganet
Question I am having the same problem with Ubuntu 6.06 and MYSQL
Hello group.
UBUNTU 6.06
Postfix
MYSQL

I am working on my new www/SMTP server and presently have an issue with MYSQL when attempting to start MYSQL.
I am working with the tutorial at : How to set up a mail server on a GNU / Linux system.

When I run '/etc/init.d/mysql start' I receive the following error...

Code:
...failed or took more than 6s.
		Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
I took a look inside of the 'syslog' here are it's contents...

Code:
Aug 20 17:01:14 72 /etc/init.d/mysql[29750]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 20 17:01:14 72 /etc/init.d/mysql[29750]:
Aug 20 17:09:01 72 /USR/SBIN/CRON[29946]: (root) CMD (  [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -r -0 rm)
Aug 20 17:09:01 72 /USR/SBIN/CRON[29948]: (root) CMD (  [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxlifetime) -print0 | xargs -r -0 rm)
Aug 20 17:17:01 72 /USR/SBIN/CRON[30164]: (root) CMD (   run-parts --report /etc/cron.hourly)
Aug 20 17:20:47 72 mysqld_safe[30336]: started
Aug 20 17:20:47 72 mysqld[30339]: 070820 17:20:47  InnoDB: Started; log sequence number 0 43655
Aug 20 17:20:47 72 mysqld[30339]: 070820 17:20:47 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Aug 20 17:20:47 72 mysqld[30339]: 070820 17:20:47 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Aug 20 17:20:47 72 mysqld[30339]: 070820 17:20:47 [ERROR] Aborting
Aug 20 17:20:47 72 mysqld[30339]:
Aug 20 17:20:47 72 mysqld[30339]: 070820 17:20:47  InnoDB: Starting shutdown...
Aug 20 17:20:50 72 mysqld[30339]: 070820 17:20:50  InnoDB: Shutdown completed; log sequence number 0 43655
Aug 20 17:20:50 72 mysqld[30339]: 070820 17:20:50 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 20 17:20:50 72 mysqld[30339]:
Aug 20 17:20:50 72 mysqld_safe[30367]: ended
Aug 20 17:21:03 72 /etc/init.d/mysql[30490]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 20 17:21:03 72 /etc/init.d/mysql[30490]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 20 17:21:03 72 /etc/init.d/mysql[30490]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 20 17:21:03 72 /etc/init.d/mysql[30490]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 20 17:21:03 72 /etc/init.d/mysql[30490]:
Aug 20 17:23:38 72 mysqld_safe[30657]: started
Aug 20 17:23:38 72 mysqld[30660]: 070820 17:23:38  InnoDB: Started; log sequence number 0 43655
Aug 20 17:23:38 72 mysqld[30660]: 070820 17:23:38 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Aug 20 17:23:38 72 mysqld[30660]: 070820 17:23:38 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Aug 20 17:23:38 72 mysqld[30660]: 070820 17:23:38 [ERROR] Aborting
Aug 20 17:23:38 72 mysqld[30660]:
Aug 20 17:23:38 72 mysqld[30660]: 070820 17:23:38  InnoDB: Starting shutdown...
Aug 20 17:23:40 72 mysqld[30660]: 070820 17:23:40  InnoDB: Shutdown completed; log sequence number 0 43655
Aug 20 17:23:40 72 mysqld[30660]: 070820 17:23:40 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 20 17:23:40 72 mysqld[30660]:
Aug 20 17:23:40 72 mysqld_safe[30688]: ended
Aug 20 17:23:53 72 /etc/init.d/mysql[30811]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 20 17:23:53 72 /etc/init.d/mysql[30811]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 20 17:23:53 72 /etc/init.d/mysql[30811]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 20 17:23:53 72 /etc/init.d/mysql[30811]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 20 17:23:53 72 /etc/init.d/mysql[30811]:
I am quite confident that this is nothing more than a missing file, but I am pruley stumped how to replace it if that is all that is required at this point??

Thanks for your help

Regards
giganet is offline  
Old 01-16-2009   #4 (permalink)
Just Joined!
 
Join Date: Jan 2009
Posts: 1
Solution for mysqld.sock missing: adding symbolic link in /tmp to mysqld.sock works!
Hey guys,

I am running ubuntu and was trying to install Mysql. I was getting the error:

InnoDB: Started; log sequence number 0 43655
090116 12:54:09 [ERROR] Can't start server : Bind on unix socket: Permission denied
mysqld[21068]: 090116 12:54:09 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?

After being stumped for a long time, I was desperate enough to try the fix suggested in this thread. It worked!!!!

Specifically, I typed the following:

#cd /tmp
# sudo ln -s /var/run/mysqld/mysqld.sock mysqld.sock
#sudo /etc/init.d/mysql start &

And mysql was running just fine!

Thought I would share this with you all so that you know this solution is valid and working as of Jan 16, 2009.

Srikanth.
sbangalore is offline  
Closed Thread

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Free Magazines
Free Network Mapping Tool for Microsoft® Office Visio® Professional 2007 Users
Don't map your network by hand – let LANsurveyor Express for Microsoft Visio Professional 2007 automatically create network diagrams for you.
subscribe
Free eBook:"Vulnerability Management for Dummies"
Get all the Facts and See How to Implement a Successful Vulnerability Management Program.
subscribe
Google vs The World: The Battle of the Message Security Vendors
With such a powerful name behind it, Google Message Security stands out in a sea of products that do exactly the same thing - or so they say.
subscribe

Safe, Secure Backup


All times are GMT. The time now is 08:17 PM.





Advertise About Us Contact Us Write For Us Archive Top
© 2000 - 2009 - All Rights Reserved - Property of  MAS Media

Content Relevant URLs by vBSEO 3.3.0 RC2