Tell me more ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.
up vote 0 down vote favorite

Sorry if this is the wrong place to post. I upgraded to 12.04 and mysql stopped working. I re-installed mysql server package. When I try to log on to database I get:

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

That file (mysqld.sock) doest not exist. Yet mysqld process is up and running. I see it when I go ps -ef.

Shutdown and restart mysql works fine, I just can't log on. I have my database on a directory that is not the default installation data directory. I added my path to the apparmor configuration file.

share|improve this question

1 Answer

up vote 0 down vote

reset MySQL password . you lose nothing . I am sure . 

 http://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password

that URL can help you .

share|improve this answer
Sorry, I tried that, didn't work. When I do step 3 to change the password I get the same error. $ mysql -u root mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) $ – user126383 Jan 27 at 20:00
I also tried reconfiguring with: sudo dpkg-reconfigure mysql-server-5.5 I got an error: Unable to set password for the MySQL "root" user. – user126383 Jan 27 at 21:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.