How do I retrieve my MySQL username and password? - Stack Overflow

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 ...

stackoverflow.com