How to recover MySQL’s “root” password quickly

Have you ever been in a rush or just had a complete brain freeze with your MySQL passwords?

Well…..I have.  🙂

——————————-

Step # 1 : Stop mysql service

——————————-

Step # 2: Start to MySQL server w/o password:

——————————-

Step # 3: Connect to mysql server using mysql client and setup the new root password:

——————————-

Step #4: Stop and Restart MySQL Server: (try your new $PASSWORD)

——————————-

Note: There are other ways to reset the password, but I like this one.

Bookmark the permalink.

Leave a Reply