MySql root password reset

1. Stop mysqld and restart it with:

   # service mysqld stop
   # mysqld_safe --skip-grant-tables --user=root

2. Connect to the mysqld server with this command:

   sql> mysql -u root

3. Issue the following statements in the mysql client:

   mysql> UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';
   mysql> FLUSH PRIVILEGES;

Advertisement