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