Skip to main content

You are here

Resetting MySQL root password

1. End current mysql process
2. Run MySQL safe daemon with skipping grant tables

mysqld_safe --skip-grant-tables &

3. Login to MySQL as root with no password:

mysql -u root mysql

4. Run UPDATE query to reset the root password
- In MySQL command line prompt issue the following two commands:

     UPDATE user SET password=PASSWORD("NEWPASSWD") WHERE user="root";
     FLUSH PRIVILEGES;
Premium Drupal Themes by Adaptivethemes