How to Change Root Password for MySQL?

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

1. Log in to the MySQL server using the current root password:
mysql -u root -p
2. Enter the current root password when prompted.
3. Once logged in, use the following command to change the root password:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
4. Replace 'new_password' with your desired new password.
5. After executing the command, don't forget to flush privileges to ensure the changes take effect:
FLUSH PRIVILEGES;
6. You have successfully changed the root password for MySQL!

Remember to keep your new password secure and follow best practices for password management to protect your database from unauthorized access.