Then I found this page on reseting apache/mysql/php on Leopard and one of the comments (Lazeez's) got me close:
/usr/local/mysql/bin/mysqladmin -u root password ’somepassword’
where ’somepassword’ is the password you want for the root user of Mysql.This doesn't work for MAMP obviously, but it led me to search for the "mysqladmin" file. I found it at
Therefore, the following command, pasted into terminal did the trick:
/Applications/MAMP/Library/bin/mysqladmin -u root -p password ’somepassword’
It will ask you for your existing mysql password, so hopefully you have that. In my case the whole problem was caused when I decided to delete the existing root password in phpmyadmin (setting it to "") while that account was still set to require a password.
Hopefully this helps someone.
Blogged with Flock