Skip to main content

how to reset mysql root password

Problem :

1. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Solution : Rest root password
     
  • sudo dpkg-reconfigure mysql-server-5.5
             This will change the root password.

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

Solution :  ps ax | grep mysql
                 sudo service mysql start
                 mysql start/running, process 7226

Comments

Popular posts from this blog

Backslash on mac

I had been struggling to type back slash ( \) character on mac japanese keyboard as they don't have it printed on the keyboard, and I was doing copy paste all the time from google when i needed to type it until recently a tip came to my rescue , shortcut to backslash on mac japanese keyboard. Alt + ¥  Hope it helps others.