How to reset MySQL root password through SSH on CentOS Linux server?

You can reset your MySQL root password if you forget that or you are having any issue related to that.

1. First of all, log into the server as root using SSH.

2. Now, stop MySQL service:

# /etc/init.d/mysql stop

Click to expand...

3. Start MySQL server without password:

# mysqld_safe --skip-grant-tables &

Click to expand...

4. Connect to MySQL:

# mysql -u root

Click to expand...

5. Setup new MySQL root password:

mysql> use mysql;
mysql> update user set password=PASSWORD("newpassword") where User='root';
mysql> flush privileges;
mysql> quit

Click to expand...

6. Stop MySQL Server:

# /etc/init.d/mysql stop

Click to expand...

7. Stop and start the MySQL service and test it:

# /etc/init.d/mysql stop
# /etc/init.d/mysql start
# mysql -u root -p

Click to expand...