So you’ve forgotten your MySQL root password have you? As long as you have command line access to the MySQL server, never fear! Execute the following bit of code from your MySQL bin directory, replacing YOURPASSWORD with your new password.
mysqladmin -u root password YOURPASSWORD
Easy as pie!
