AutoMysqlBackup: Warning: Using a password on the command line interface can be insecure.

AutoMysqlBackup: Warning: Using a password on the command line interface can be insecure.

Since MySQL 5.6 AutoMysqlBackup comes back every day with an error mail containing the lines “Warning: Using a password on the command line interface can be insecure.”

Since there is no update of AutoMysqlBackup yet I decided to give it a quick fix myself.

On line 115 there is a line that says

removeIO

Add this after removeIO:

 # Remove annoying warning message since MySQL 5.6
 if [[ -s "$log_errfile" ]]; then
 sedtmpfile="/tmp/$(basename $0).$$.tmp"
 grep -v "Warning: Using a password on the command line interface can be insecure." "$log_errfile" > $sedtmpfile
 mv $sedtmpfile $log_errfile
 fi

And you will receive no more daily emails regarding that it is unsafe to use passwords on the command line.

11 thoughts on “AutoMysqlBackup: Warning: Using a password on the command line interface can be insecure.

  1. Mark

    This line is not in version 3.0_rc2, I wonder how this error is triggered then, I still get four of these errors each backup (even though 20+ databases are being backed up)

    1. Hi,

      I don’t see an rc2 file between the downloadable files on sourceforge so I cannot check but there probably is a line similar as rc1 and rc6 were released within a month 🙂

  2. I was using 3.0_rc6 and came across the same issue in the email subject and the attached log file. Thanks a lot for this quick fix!

  3. Fernando Nunes

    Thanks for the fix.

  4. Urid Lugo

    Thanks for the fix. Excelent

Geef een reactie