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.