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