search

davidsoergel / s3napback

Cycling, Incremental, Compressed, Encrypted Backups to Amazon S3.
Other
15 stars 3 forks source link

How do I customize the database user credentials? #6

Closed bkuhl closed 9 years ago

bkuhl commented 9 years ago

I'm currently running into an issue where I get the below error during mysql backups:

mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: NO)" when trying to connect

Is there a way for me to customize the credentials for the database connection?

davidsoergel commented 9 years ago

The user you're running the script as must be able to mysqldump the requested databases without entering a password. This can be accomplished through the use of a .my.cnf file in the user's home directory, containing e.g.

[mysqldump]
user=mysqluser
password=secret