Is it possible to disable the "mysql: [Warning] Using a password on the command line interface can be insecure" warning?
+2
−0
For my purposes, it is secure enough to use passwords to execute MySQL commands on the command line, what I would like to do is disable the warning that says,
mysql: [Warning] Using a password on the command line interface can be insecure
because that warning distracts from more pertinent errors.
Is disabling that warning possible?
1 answer
+2
−0
There are multiple ways to do this. Just picked two that I find more usable (not very insecure or hard to do).
-
Use a configuration file to store the credentials
mysql --defaults-extra-file=/full/path/to/config.cnf
and the configuration file should contain the login data:
[client]
user = "user"
password = "password"
host = "host"
-
Keep the command, but filter out the error by piping a grep command:
mysql <options> 2>&1 | grep -v "Warning: Using a password"
0 comments
0 comments