Cron command without using password to access MYSQL database

Question

Good personal day, lately I’ve been receiving warnings related to a cron I created on 1 site to update certain data from a mysql database table.

The error is as follows:

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

How do I fix this issue since I need to access the bd to update it?

mysql --user=usuario --password='senha' --database=bancodados --execute="UPDATE protocolos P INNER JOIN reclamacao R SET P.status = 'Em atraso' WHERE P.id = R.id_protocolo AND P.status='Em aberto' AND DATEDIFF(NOW(),R.data_registro) >= 20

Someone would know how to do the same action without having to put the password in charge?

Thank you

Answer 1

You can use the mysql_config_editor to configure access and avoid passing the login/password opened on the command line:

mysql_config_editor set --login-path=local --host=localhost --user=usuario --password=senha

Then just run without the need to login/password:

mysql --execute="UPDATE protocolos P INNER JOIN reclamacao R SET P.status = 'Em atraso' WHERE P.id = R.id_protocolo AND P.status='Em aberto' AND DATEDIFF(NOW(),R.data_registro) >= 20

Here the command reference: mysql-config-editor