Resetting MySQL Root Password on MacBook Pro Catalina

If you have forgotten the root password for MySQL on your MacBook Pro running Catalina, don't worry, there is a way to reset it. Follow the steps below to regain access to MySQL:

1. Stop the MySQL server: Open Terminal and enter the command sudo /usr/local/mysql/support-files/mysql.server stop
2. Start MySQL in safe mode: Enter the command sudo mysqld_safe --skip-grant-tables
3. Open a new Terminal window and log in to MySQL without a password: Enter the command mysql -u root
4. Set a new password: Once logged in, use the following MySQL commands to change the root password:
   FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
5. Restart the MySQL server: Stop the running MySQL process and restart it normally using the command sudo /usr/local/mysql/support-files/mysql.server start
6. You should now be able to log in to MySQL using the new password

Remember to keep your MySQL root password secure and make sure to use a strong, unique password to protect your data.

Additional Links

How To Reset Mysql Root Password Mac
How To Reset Mysql Root Password
How To Reset Mysql Root Password Ubuntu
How To Reset The Root Password In The Mysql Reference Manual Mac
How To Change Root Password For Mysql In Mac
How To Reset Password Mysql Mac

How To Delete Icloud Without Password Ios 11