Technical Blog

How to recover the mysql root password ?


First stop the mysql service and Start to MySQL server without  password using this command 
# mysqld_safe --skip-grant-tables 
& Connect to mysql server using mysql client:
# mysql -u root and use below commands
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
Posted by Unknown No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
Buy Apple MacBook Pro MF840HN/A Notebook (Intel Core i5- 8GBRAM- 256GB ... from Snapdeal

Blog Archive

  • ►  2015 (1)
    • ►  January (1)
  • ►  2014 (6)
    • ►  December (1)
    • ►  October (1)
    • ►  September (1)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2013 (10)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  May (1)
    • ►  February (1)
    • ►  January (3)
  • ▼  2012 (4)
    • ►  December (1)
    • ►  September (2)
    • ▼  July (1)
      • How to recover the mysql root password ?
  • ►  2011 (1)
    • ►  January (1)
  • ►  2010 (7)
    • ►  December (4)
    • ►  June (2)
    • ►  March (1)
  • ►  2009 (23)
    • ►  December (18)
    • ►  November (2)
    • ►  October (3)

About Me

Unknown
View my complete profile

Categories

  • DOS [COMMAND] (4)
  • Java (2)
  • JavaScript (2)
  • Linux (1)
  • MDX (1)
  • Mondrian (1)
  • postgres (1)
  • Registry Hack (6)
  • Trick (16)
  • Virus (4)
Simple theme. Powered by Blogger.