Mysql password warning in bash script

Question

I am currently running mysql through bash. However it returns the error:

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

What are the secure ways to accomplish this? How can I properly call the mysql without this warning?

#!/bin/bash/ user=test password=test database=test mysql --user='$user' --password='$password' --database='$database' --execute='DROP DATABASE $user; CREATE DATABASE $database;'

Result

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

I don't think the error has anything to do with the user of the variable. — Barmar
– Barmar, Commented May 28, 2015 at 21:11
Does the warning go away if you use <(/home/yourusername/bin/ffprobe -i "$file" -show_format -v quiet | grep '.=.')? — Barmar
– Barmar, Commented May 28, 2015 at 21:12

pasaba por aqui · Accepted Answer · 2015-05-28 21:36:23Z

2

You command opens a mysql session passing as argument the mysql password (I see this message tenths at day).

answered May 28, 2015 at 21:36

pasaba por aqui

3,5771 gold badge20 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Code_Ed_Student Over a year ago

Oh yes, this was also an issue. It was below a few lines below the script shown above.

Barmar · Accepted Answer · 2015-05-29 00:32:31Z

Instead of putting the password on the command line, create a ~/.my.cnf file, and put the password in there. The file can supply default values for any of the command line options. For instance, you can put this in it:

[client] database = test user = test password = test

Then you can just run:

mysql --execute='DROP DATABASE $user; CREATE DATABASE $database;'

Make sure the file's permissions are restricted, so unauthorized users can't see the password.

Collectives™ on Stack Overflow

Mysql password warning in bash script

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related