How to securely login to MySQL database in shell script
- Use mysql_config_editor to set up a password file.
mysql_config_editor set --login-path=local --host=localhost --user=peacock --password
user_name and password are encrypted and saved in your /home_dir/.mylogin.cnf
- Change your bash script
mysql --login-path=local <<EOF
--your sql script ...
EOF
or:
from :
mysqldump -u peacock -pLogin_Password database_name | gzip > database_backup.gz
to:
mysqldump --login-path=local database_name | gzip > database_backup.gz