Home error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Reply: 0

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

user3491
1#
user3491 Published in June 25, 2018, 12:18 am

My problem started off with me not being able to log in as root anymore into my mysql install. I was attempting to run mysql without passwords turned on... but whenever I would run the command :

    # mysqld_safe --skip-grant-tables &

I would never get a prompt back... (I was trying to follow the instructions here: http://www.cyberciti.biz/tips/recover-mysql-root-password.html) The screen just looks like this:

 root@jj-SFF-PC:/usr/bin# mysqld_safe --skip-grant-tables
 120816 11:40:53 mysqld_safe Logging to syslog.
 120816 11:40:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

and I don't get a prompt to start typing the sql commands to reset the password.

When I kill it by doing a CTRL + C, I get the following message:

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!

If I retry the command and leave it long enough, I do get the following series of messages:

root@jj-SFF-PC:/run/mysqld# 120816 13:15:02 mysqld_safe Logging to syslog.
120816 13:15:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120816 13:16:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[1]+  Done                    mysqld_safe --skip-grant-tables
root@jj-SFF-PC:/run/mysqld#

But then if i try to log in as root by doing:

# mysql -u root

I get the following error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I checked and /var/run/mysqld/mysqld.sock file doesn't not exist. The folder does, but not the file.
Also, I dunno if this helps or not, but I found did a find / -name mysqld and it came up with:

/var/run/mysqld - folder
/usr/sbin/mysqld - file
/run/mysqld - folder

I'm just new to linux and mysql, so i don't know if this is normal or not. But I'm including this info just in case it helps ...

** I finally decided to uninstall and reinstall mysql. **

apt-get remove mysql-server
apt-get remove mysql-client
apt-get remove mysql-common
apt-get remove phpmyadmin

After resintalling all packages again in the same order as above, during the phpmyadmin install, it gave me the same error -

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

So I tried again to uninstall/reinstall. This time, after I uninstalled the packages, I also manually renamed all mysql files and directories to mysql.bad in their respective locations.

 /var/lib/mysql 
 /var/lib/mysql/mysql
 /var/log/mysql
 /usr/lib/perl5/DBD/mysql
 /usr/lib/perl5/auto/DBD/mysql
 /usr/lib/mysql
 /usr/bin/mysql
 /usr/share/mysql
 /usr/share/dbconfig-common/internal/mysql
 /etc/init.d/mysql
 /etc/apparmor.d/abstractions/mysql
 /etc/mysql

Then I tried to reinstall mysql-server, mysql-client again. But I've noticed that it doesn't prompt me for a password. Isn't it supposed to ask for an admin password?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.456866 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO