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.cnfIt 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.1Step 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.
Last updated on August 4, 2021