mysqldump: Got error: 1045 Access denied
mysql
Solution
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
Problem
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