My WordPress site is complete and ready to take live. I've been developing it locally using MAMP (on my Mac running 10.7.4). For some unknown reason, I am unable to access phpMyAdmin, or even connect to the site. I've been receiving the "#1045 - Access denied for user 'root'@'localhost' (using password: NO)" error. I have not changed any passwords.
All I really need is a dump of the database so I can import it into phpMyAdmin on my live server (which I can access).
I've tried accessing mysql through Terminal. I'm attempting to reset the root user password (which I think is the problem, but I could be wrong).
I've used the terminal command:
/Applications/MAMP/Library/bin/mysqld_safe --skip-grant-tables --skip-networking to start the mysqld daemon, which returns
mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
From here, things go down hill.
When I attempt to run
mysql mysql -uroot so I can log in and make changes to the database, I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2)
I'm banging my head against my keyboard at the moment. I can't do a dump of the database because root@localhost doesn't have permissions, and I can't change permissions for some reason. Anyone have any ideas?