How to reset mysql root password ?

By admin • March 26, 2009 • Filed in: Articles

1. Stop/ kill the mysqld
# service mysql stop
#pkill -9 mysqld

2) Start the mysql insafe mode as follows

# /usr/libexec/mysqld --skip-grant-tables --user=root &

3) Now update the mysql user tables and root password as follows

#mysql
mysql>use mysql;
mysql>UPDATE user SET Password=PASSWORD('YOUR_PASSWORD')  WHERE Host='localhost' AND User='root';
mysql>flush privileges;

Now add the new password “YOUR_PASSWORD” in /root/.my.cnf and start mysql

# service mysql start

Popularity: 1%

Comments are closed.

Blogroll