mysqldump: Got error: 1045 Access denied

Question

I am logged into an AWS instance and trying to copy a mysql database to a .sql file. I am using the command:

mysqldump -u [username] -p [databasename] > [database].sql

Then entering the password and the following message comes up.

"mysqldump: Got error: 1045: Access denied for user '[username]'@'localhost' (using password: YES) when trying to connect."

I can login directly to mysql using the same credentials as above, but still get the same error. I have tried a bunch of different ways for the command above, but it seems to be an issue with permissions or something similar. The user does have all privileges for the database when looking in phpmyadmin so I am not sure what is wrong? Any suggestions? Thanks

Answer 1

This works for me:

mysqldump -uroot -pxxxx dbname > dump.sql

or you can specify the host:

mysqldump -h localhost.localdomain -uroot -pxxxx dbname > dump.sql

Check to make sure you don't have different instances of mysql running

Answer 2

Thank you all for your input! It got me thinking about what else it could possibly be. I then tried using the -h parameter as well, which wouldn't work with "localhost". It finally worked when I used the Private IP Address for the AWS instance.
mysqldump -h [PrivateIPAdress] -u [UserName] -p [DatabaseName] > [Database].sql