How to set mysql password automatically in bash script?

Question

I have a bash script that opens queries from MySQL. For example:

$ cat script.sh 
mysql -u joe -D database -p ........ < first_query.sql
mysql -u joe -D database -p ........ < second_query.sql

This 2 lines inside my script.sh file return the results of the queries, but: Everytime I call the ‘mysql’ command, if it has the «-p» option, it asks for password TWICE (because I call mysql twice). How can I avoid this behavior?

I have tried passing my password as parameter, for example:

$ sh script.sh ‘mypassword’

and storing it in a variable and putting it after the «-p» option. But it still asks for the password twice.

You have two valid answers. You should pick your favorite and mark this question as resolved. — Das_Geek
– Das_Geek, Commented Apr 29, 2019 at 18:03

deleb · Accepted Answer · 2019-04-25 21:27:37Z

2

You can place your password staight after the -p. If you password is "123asd", the command will be:

mysql -u user -p123asd

Make sure there are no spaces between -p and your password.

answered Apr 25, 2019 at 21:27

deleb

6145 silver badges7 bronze badges

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

Comments

Das_Geek · Accepted Answer · 2019-04-25 21:18:55Z

1

Probably the simplest way would be to edit your my.cnf (found in /etc/mysql/ by default) to include your password, like so:

[client]
user = joe
password = ......

answered Apr 25, 2019 at 21:18

Das_Geek

2,8557 gold badges23 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to set mysql password automatically in bash script?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related