avoid asking second time mysql root password (bash)

Question

In a simple script like this one:

set -x
# Check if db exists, if not we make it, make user, give privileges
if ! mysql -u root -p -e "use $db" 2>/dev/null; then

    c1="CREATE DATABASE $db"
    c2="GRANT ALL PRIVILEGES ON ${db}.* to '$username'@'localhost' IDENTIFIED BY '$password'"
    c3="FLUSH PRIVILEGES"

    mysql -u root -p -e "$c1; $c2; $c3"
else
    echo 'DATABASE ExISTS, ABORTING'; exit $DB_EXISTS
fi

I am asked each time, bash sees mysql command, for my root credentials. Is there a way to avoid that, so that once entered the root password, all additional mysql commands execute seamlessly?

You can ask for password, store it in a separate variable and pass it in the command as: mysql --password $pass_var — hjpotter92
– hjpotter92, Commented Oct 16, 2014 at 23:47

Community · Accepted Answer · 2017-05-23 12:05:58Z

4

Try looking into adding password to ~/.my.cnf

[client]
user = root
password = XXXXXXXX

Check out :

How to execute a MySQL command from a shell script?

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Oct 16, 2014 at 23:52

lvolmar

2,2801 gold badge14 silver badges8 bronze badges

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

1 Comment

Sammitch Over a year ago

There's also a very poorly-documented flag that allows you to specify a particular file: mysql --defaults-extra-file=/path/to/.my.cnf

Francisco Rodeño Sanchez · Accepted Answer · 2021-01-24 10:16:48Z

0

Specifying the --password argument

mysql -u root --password=my_mysql_pass db_name

Safer using a bash variable

mysql -u root --password=$MYSQL_PASS db_name

answered Jan 24, 2021 at 10:16

Francisco Rodeño Sanchez

7371 gold badge9 silver badges20 bronze badges

Collectives™ on Stack Overflow

avoid asking second time mysql root password (bash)

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related