How do I Retrieve my MySQL Username and Password?


I lost my MySQL username and password. How do I retrieve it?



Answer : 

     Stop the MySQL process.
     Start the MySQL process with the --skip-grant-tables option.
     Start the MySQL console client with the -u root option.
List all the users;
SELECT * FROM mysql.user;
Reset password;
UPDATE mysql.user SET Password=PASSWORD('[password]') WHERE User='[username]';
But DO NOT FORGET to
     Stop the MySQL process
     Start the MySQL Process normally (i.e. without the --skip-grant-tables option)
when you are finished. Otherwise, your database's security could be compromised.


TAGS : | |