<p>I lost my MySQL username and password. How do I retrieve it?</p>

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.