Hopefully this is something simple. First off, my local MAMP site is producing this error upon startup, "Error message:
/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect"
I encountered this before but I can't remember how I resolved it.
Next, my live site is fine, everything is updated and current. I created a new MAMP site. I exported my database from my live site, brought it into my MAMP site. MAMP site looks fine as far as theme and structure, however I am missing my primary links, nodes, images, pretty much everything that is in my node revisions table. Upon looking at my MAMP files under database I have found these three files, "node_revisions.MYI, node_revisions.myd, node_revisions.frm. Hopefully I have provided enough info for someone to offer a solution. Thanks in advance.

Comments
MAMP problems
Have you tried going into PHPMyAdmin and adding a password to your user account?
http://drupal.org/node/49710
Oh yes. I did the password
Oh yes. I did the password thing across the board. I just find it strange that I have no nodes, etc. The 1045 error, stumped.
Sounds like your database
Sounds like your database export didn't actually copy over. Are you using phpmyadmin or mysql commandline to do import/export?
I've done it a number of
I've done it a number of times. Used PHP and backup/migrate mod. Same result. local host 1045 error popped up as well.