Reset mysql root password on Mac M1

mysql8-m1-reset-password.md

1. Make sure mysql service stopped mysql.server stop or brew services stop mysql
2. Create a text file somewhere ex. /Users/iambudi/reset_pass.txt and write this one liner sql to the file:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'ReplaceNewPassHere';

3. Run mysql service mysqld --init-file=/Users/iambudi/reset_pass.txt
4. Connect to mysql using the new password

When things goes okay, delete the reset_pass.txt, stop and start mysql again.