timbroder.com

This came in veeeerrryyy handy just now…

1. Stop the MySQL Server

   sudo /etc/init.d/mysql stop
    

2. Start the mysqld config

   sudo mysqld –skip-grant-tables &

3. Login to the server as root

   mysql -u root mysql

4. Ser your NEWPASSWORD

   UPDATE user SET Password=PASSWORD(‘NEWPASSWORD’) WHERE User=’root’; FLUSH PRIVILEGES; exit;