How to create a Passwordless MySQL Backup

How to use MySQL configuration file to allow authentication without credentials for MySQL backups.

You can instruct SimpleBackups to take a passwordless MySQL backup for you.

This is a very useful feature if you want to ensure that your credentials are not stored in anywhere other than your own server. But, it requires that you trust your server and can actually allow anyone logged in to that server to access MySQL without a password.

Step 1. Create my.cnf file or edit existing one

vi /etc/my.cnf

It could also be in /etc/mysql/my.cnf or /etc/mysql/conf.d/client.cnf assuming that these files are included in your main config file.

Step 2. Add your credentials to under the client section

Ensure you replace these values by your actual ones.

[client]
user=MYSQL_USER
password=MYSQL_PASSWORD
port=3306
host=127.0.0.1

Step 3. Verify that you can connect to MySQL without a password

Just type mysql in the command line and test if it will log you in without having to give credentials.

Step 4. Create a backup and select the following options

Note: this cannot be used with the "Serverless" option, and can only be used if you use your own server to dump the database.

Did this answer your question?
😞
😐
🤩

Last updated on August 4, 2021