My log files are getting dumped with following message while running shell scripts using some underlying MySQL commands.
Here is the message:
"Warning: Using a password on the command line interface can be insecure."
To stop these messages, I am using the following job definition.
run_wrapper.sh |grep -v "Warning: Using a password" > output.log 2>&1
This worked but the MySQL errors are not being logged to
If I change the definition like the following, then MySQL errors start appearing if any
run_wrapper.sh > output.log 2>&1
So the question is how to suppress the warning messages and also report SQL errors in log files using only the cron definition?