How to Change Root Password in MySQL

Changing the root password in MySQL is an important step in enhancing the security of your database. Follow these steps to change the root password in MySQL:

1. Log in to your MySQL server as the root user using the current password.
2. Run the following command to update the root password: ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
3. Replace 'new_password' with your desired strong password.
4. Flush privileges to apply the changes: FLUSH PRIVILEGES;

That's it! Your MySQL root password has been successfully changed.