Username: root
Password: whatever you set it. You can reset the password in the MySQL tab of MAMP.
Host: localhost
Database: Use the name of the database you just created.
Also, you need to edit the $tmp_path and $log_path to add the path to your website folder. For example, if you put the website folder in the Sites directory in your own user account, then the path is
/Users/[user-name]/Sites/newsite/logs and /Users/[user-name]/Sites/newsite/temp
Use phpMyAdmin to search the wp_options table for the domain name of the live website. You should get two results. Change both of these to your local domain; in my case, newsite.dev
Gordon says
Nice tutorial Pat work perfectly for me. If you have MAMP (2.1.1) and Mountain Lion (10.8.2) you must also turn off Apache in the Mountain Lion OS. I used the “sudo apachectl stop” command with Terminal. Hopefully this issue will resolve itself with either a future MAMP or Mountain Lion update.