A blog for Linux Lovers.

Posted by sibu on March 10, 2009

Mysql root password reset.

To reset MySQL root Password

1. Kill/Stop the MySQL Service
# pkill mysql / /etc/init.d/mysqld stop

2. Start mysql in safe mode
# safe_mysqld –skip-grant-tables & [OR]
# mysqld_safeĀ  –skip-grant-tables &

3. Connect to mysql
# mysql mysql

4. Update the root user Password
mysql> UPDATE user SET Password=PASSWORD(’New_Password’) WHERE Host=’localhost’ AND User=’root’;

5. Exit and kill mysqld_safe / safe_mysqld
# pkill mysqld_safe / safe_mysqld

6. Start the MySQL Service
# /etc/init.d/mysql start

7. Connect to your Mysql
# mysql -u root -p
Enter Password: Specify your New_Password

Add A Comment