Force change/reset mysql password?
I'm having trouble with my MAMP installation where I can't seem to connect to the database.
I thought I knew the password, but it doesn't work and I can't log into mysql manually with it.
I want to hard reset the root password for the MAMP installation of mysql, can I do that?
start mysql with --skip-grant-tables to bypass the login system. that'll let you in as a superuser, and you can modify user accounts.
Afterwards, use flush privileges to restore the access control system.
Type this in your terminal:
/Applications/MAMP/Library/bin/mysqladmin -u root -p password <YOUR_PASS>
If your password not working, use flush privileges