Password on the command line interface can be insecure

[mmenozzi]

With MySQL 5.6 every run of automysqlbackup will generate the following warning (and potentially an error email):

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

This is because automysqlbackup uses username and password directly on the mysql command for the connection.

Here the problem has been solved:
http://www.redeo.nl/2013/11/automysqlbackup-warning-using-password-command-line-interface-can-insecure/

But I don't know if this is the cleanest solution.

[FernandoNunes]

Also applied the linked fix, can you address this issue on next release ?

[Powertrain]

Applied the linked fix on a large professional scale. Would greatly appreciate incorporation into next release.

[alasdaircr]

Or perhaps take the advice and not show passwords on the command line.

hi, fixed in https://github.com/ppadial/autoMySQLBackup master, cause it seems to be outdated

[kronos-pbrideau]

I'm a bit late to the party, but for reference, it looks to me this is a better way to deal with this problem no? :
msilvoso@3f4a557

[jeffmcneill]

@kronos-pbrideau That looks like a better way. See also http://stackoverflow.com/a/22933056/552983

I can't believe this still isn't fixed. Just upgraded to ubuntu server 16.04 and started getting daily emails full of warnings. The solution at redeo.nl does not work for me. Running v3.0-rc6 currently.

[BlackBeltPanda]

Also having this issue on Ubuntu 17.04 with automysqlbackup 2.5 and MySQL 5.7.

[FernandoNunes]

For me the issue is fixed on Ubuntu 16.04.2 LTS
Package: automysqlbackup
Version: 2.6+debian.4-1

[noqqe]

Not sure why nobody is pointing this out here, but the only real solution to this problem is adding an option to use a defaults-file/my.cnf for auth rather than --password.

Obscure wrappers and greps also do not solve the problem that mysqldump is extting with 1 instead of 0.

[Harery]

please help
how to solve below error

WARNING

Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysql: [Warning] Using a password on the command line interface can be insecure.

[fakhamatia]

I have the same problem

[alvxyz111]

Hello anyone resolves this issue?

[EasyG0ing1]

@rcruz And here we are - 2023 ... any hope for solving this problem? I use MySQL v 8 ... would love to get this program up and working on all cylinders.

Thank you,
☺
Mike Sims