How to grant MySQL privileges in a bash script?

Question

I need to grant privileges to a database from within a bash script. Some parameters are in the form of variables, say, the username and the password. The command in a mysql shell would look like this:

GRANT ALL ON *.* TO "$user"@localhost IDENTIFIED BY "$password";

...Except that $user and $password would be replaced by their values.

Is there a way to perform such a command from within a bash script?

Thank you!

Jauzsika · Accepted Answer · 2011-09-23T13:16:49.417

7

There you go :)

#!/bin/bash

MYSQL=`which mysql`
EXPECTED_ARGS=3

Q1="USE $1;"
Q2="GRANT ALL ON *.* TO '$1'@'localhost' IDENTIFIED BY '$2';"
Q3="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}"

if [ $# -ne $EXPECTED_ARGS ]
then
  echo "Usage: $0 dbname dbuser dbpass"
  exit $E_BADARGS
fi

$MYSQL -uroot -p -e "$SQL"

edited Sep 23 '11 at 13:16

answered Sep 23 '11 at 12:38

Jauzsika

3,171
3
23
32

I am sorry but that's not an answer to my question. – Dunaril Sep 23 '11 at 13:13
@Dunaril why do you say that this is not an answer to your question? It looks, at first glance, that this would work. – Icarus Sep 23 '11 at 13:22
1

@Dunaril I see. Mr. Jauzsika should get used to put **UPDATE** when he updates his answers. – Icarus Sep 23 '11 at 13:31
1

Is there a way of doing this without getting the prompt for password? – Automatico Feb 26 '13 at 11:13
1

In `grant` statement, I think we are missing `privileges`. I've tested your suggestion but it doesn't work unless I add privileges. – Tung Mar 07 '19 at 18:06

score 0 · Answer 2 · answered Oct 18 '17 at 08:54

0

If we don´t know the password we can get it with:

cat /etc/psa/.psa.shadow

So we can get into mysql without prompt password like:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

answered Oct 18 '17 at 08:54

Agusjar

3
3

How to grant MySQL privileges in a bash script?

2 Answers2