mysql: [ERROR] unknown option '--ssl'
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.
-
Hey there! I'm not familiar with this script, and it's not something that is provided by cPanel, so I can't say for sure what the issue may be. You'll likely need to examine the script, find the connection string, and adjust that. I'm unsure why a script that is basically performing a local mysql dump and then a mv on the file would need an SSL connection, but I can't say for sure.
1 -
Hello WorkinOnIt
You need to check whether SSL is properly configured and the status is enabled in your MySQL server, If you have root access, you can check the path: /etc/my.cnf or /etc/mysql/my.cnf and look out for the SSL status.
Additionally, you can verify whether the MySQL user has the necessary privileges or not.
Hope this might help!0 -
Thanks for your replies.
I fixed it by adding the following:
https://github.com/belgotux/automysqlbackup
CONFIG_mysql_no_tablespaces='no' CONFIG_mysql_column_statistics='no'
0
Please sign in to leave a comment.
Comments
3 comments