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>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

Leave a Reply

Your email address will not be published. Required fields are marked *