Sample Header Ad - 728x90

MySQL stop/waiting issues; “can't connect … through socket”

6 votes
1 answer
8882 views
So this was my first time putting up a LAMP stack on a Bodhi machine (previously experience with WAMP, and LAMP on 10.04); I got Apache going, and a Drupal install begun, then I go to create a new database and when I log in to phpmyadmin ... I get a 'cannot connect error'. Tracing this back, the issue began once I tried to get virtual hosts up and running in Apache; once that was done I started running into socket connection issues with mysql. Initially the problem looked like this: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Using ls -lart /var/run/my* I get this: total 0 drwxr-xr-x 2 mysql root 40 Jan 31 11:56 . drwxr-xr-x 21 root root 740 Jan 31 12:21 ..` I ran touch /var/run/mysqld/mysqld.sock and set chown -R mysql /var/run/mysqld which allows for: total 0 drwxr-xr-x 21 root root 740 Jan 31 12:21 .. -rw-r--r-- 1 mysql root 0 Jan 31 13:58 mysqld.sock drwxr-xr-x 2 mysql root 60 Jan 31 13:58 . - So when I try to run mysql -u root -p I get one error - ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13) (note it is no longer ERROR 2002...(2) but rather ERROR 2002...(13)) - If I try service mysql restart (or stop, start) I get another error - `start: Rejected send message, 1 matched rules; type="method_call", sender=":1.49" (uid=1000 pid=8407 comm="start mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init") ` - When I run sudo service mysql restart I get `stop: Unknown instance: start: Job failed to start ` - When I run service mysql status I get "mysql stop/waiting" What can I do to diagnose the issues I am having with mysql? I may be overlooking an utterly simple mysql issue and would appreciate any feedback on what I've done so far. Also, being a Bodhi machine and most of the instruction/feedback being written for Ubuntu, I am unsure to what extent any Ubuntu instruction may not apply. In particular, am I running into a problem related to the difference between /etc/init.d/... and service ... ... commands? Or, perhaps, am I running into a difference between libraries of the two?
Asked by mfg (171 rep)
Feb 1, 2013, 06:21 PM
Last activity: Apr 5, 2019, 11:07 PM