How to reset mysql root password ?
(No Ratings Yet)
Loading ...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%
