shell scripting grant command is not working in mysql

Question

I have created a shell script as given below.The aim is to create a database in a remote machine and give all privileges on that database for a specific user in remote machine.
The shell script is as follows.

ssh [email protected] 'echo "db name :";
read db_name;
echo "db user :";
read db_user;
echo "user password:";
read password;
host=localhost;
sql1="create database $db_name;";
sql2="grant all on ${db_name}.* to ${db_user}@${host} identified by "${password}";";
sql3="${sql1}${sql2}";
mysql -u root -p -e "${sql3}";
'

And the output Iam getting is as foloows

[email protected]'s password:
db name :
amblex
db user :
qbadmin
user password:
xxxx
Enter password: xxxx
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'qburst'
at line 1

What could be the mistake in my script.PLease help me to resolve this.

Thanks in advance.

Reference

thar45
– thar45

2013-02-28 04:06:58 +00:00
Commented Feb 28, 2013 at 4:06 — thar45
– thar45, Commented Feb 28, 2013 at 4:06

Red Cricket · Accepted Answer · 2013-02-28 04:12:25Z

0

Instead of ...

sql2="grant all on ${db_name}.* to ${db_user}@${host} identified by "${password}";";

... try this ...

sql2="grant all on ${db_name}.* to ${db_user}@${host} identified by \"${password}\";";

Also you might want to consider using expect.

answered Feb 28, 2013 at 4:12

Red Cricket

10.6k24 gold badges96 silver badges192 bronze badges

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

Collectives™ on Stack Overflow

shell scripting grant command is not working in mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related