How to Change Password MySQL CentOS 7

How to Change Password MySQL CentOS 7

If you are running a MySQL database on CentOS 7, changing the password is an essential step to ensure the security of your data. Follow these steps to change the password:

1. Log in to your CentOS 7 server.
2. Open the MySQL shell by entering the following command: mysql -u root -p
3. You will be prompted to enter the current password. Once done, press Enter.
4. Once logged in, you can change the password using the following command: ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
5. Replace new_password with your desired password.
6. After changing the password, don't forget to flush privileges by typing: FLUSH PRIVILEGES;
7. Exit the MySQL shell by typing: exit
8. Your MySQL password in CentOS 7 has been successfully changed.