How to Change Root Password in MySQL?

Changing the root password in MySQL is a critical step in maintaining the security of your database. Follow these steps to update the root password:

1. Login to MySQL with the current root password: mysql -u root -p
2. Once logged in, use the following SQL command to change the password:
   ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
3. Remember to replace new_password with your desired strong password.
4. Finally, flush privileges to ensure the changes take effect:
   FLUSH PRIVILEGES;

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