Resetting MySQL Root Password on MacBook Pro Catalina

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.