audibleCode

I am browsing blog and i just found this thing that i didn’t know

Reseting mysql password

1.  
   1.  
      1. Stop the server
         
      2. #/etc/init.d/mysql stop
         
      3. Login as root
         
      4. #mysqld_safe –skip-grant-tables –user=root
         
      5. #mysql -u root
         
      6. Enter this command
         
      7. mysql>update mysql.user set password=password(’newpassword’) where user=’root’;
         
      8. start the service again
         
      9. #etc/init.d/mysql start
         
      10. login again
          
      11. #mysql -u root -p