Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics

Dashboard
Notifications
Mark all as read
Q&A

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?

Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

0 comments

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).

  1. 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"
  1. Keep the command, but filter out the error by piping a grep command:

    mysql <options> 2>&1 | grep -v "Warning: Using a password"
    

Credit: this and this.

Why does this post require moderator attention?
You might want to add some details to your flag.

0 comments

Sign up to answer this question »