Change password root in MySQL on Redhat Centos

Method 1: If You Know the Current Root Password

Step-by-Step

1. Log in to MySQL as root:

mysql -u root -p

2. Change the root password:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewSecurePassword!';
FLUSH PRIVILEGES;
EXIT;

Make sure to replace 'NewSecurePassword!' with a strong, secure password.

Method 2: If You Forgot the Root Password

Step-by-Step

1. Stop the MySQL Service:

sudo systemctl stop mysqld

2. Start MySQL in Safe Mode (no password check):

sudo mysqld_safe --skip-grant-tables &

Wait a few seconds after this command.

3. Login without password:

mysql -u root

4. Set a new root password:

FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewSecurePassword!';
EXIT;

5. Stop the MySQL Safe Mode and Restart the Service:

sudo systemctl stop mysqld
sudo systemctl start mysqld

6. Test login with new password:

mysql -u root -p

Tips for Security

• Use a strong password with upper/lowercase letters, numbers, and symbols.

• Never leave the root account with a blank or weak password.

• Restrict remote root access for added security.