I am trying to set up magento on my localhost, and had to create a database for it via phpmyadmin. anyways, one of the setup steps was to enter in a user name and password, but it wouldn't let you leave the password blank so I went and changed it. now, I can't access anything... not MAMP, phpMyAdmin, any local sites, etc. I can't seem to change permissions via the command line.
I am the only user on my computer.
phpMyAdmin has a config file located within the same directory, called config.inc.php . Change your password there ( given that you use "config" mode to memorize password )