I recently upgraded servers - the previous OS was Centos7 running Mariadb. The new server is Rocky8 and MySql 8.0.36
On both servers, an account runs an 'automysqlbackup.sh' script which basically dumps the mysql database into a secure folder, at various intervals (crude backups). On the old server it ran like a dream. On the new server, I get the following errors reported by the script, when it runs via cron:
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [ERROR] unknown option '--ssl'.
If I disable the SSL check in the script config file, the script runs fine and dumps the db as it should. But obviously I would prefer to run it over SSL. No amount of googling has helped with this error. I am not sure what to check. The server and the user account has SSL certificates installed via let's encrypt and the SQL server appears to be running fine with no errors in error logs etc.
Thanks for any advice.
Please sign in to leave a comment.