Setting Root Password in MySQL

Setting a strong root password in MySQL is crucial for protecting your databases from unauthorized access. Follow these steps to set the root password:

1. Open your command line interface.
2. Log in to MySQL by entering the command: mysql -u root
3. Once logged in, enter the following command to set the root password: ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
4. Replace new_password with your desired strong password.
5. Finally, flush privileges to ensure the changes take effect: FLUSH PRIVILEGES;
6. Your root password should now be successfully set!

Remember to keep your root password secure and never share it with unauthorized individuals.