How to reset mysql root password ?

in Blog - Oct 06, 2017 | by Sherin - no comments

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

Recent Posts