Accessing MySQL from Ubuntu Bash

Question

Ubuntu bash mysql script looks like that

mysql -h localhost -u $MYSQLLOGIN -p$MYSQLROOTPASS  -t -e ' 
CREATE USER $USERNAME@'localhost' IDENTIFIED BY $MYSQLPASS;
create database $MYSQLDB;
grant usage on *.* to $USERNAME@localhost identified by $MYSQLPASS;
grant all privileges on $MYSQLDB.* to $USERNAME@localhost';

Getting error message

 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 '$MYSQLPASS' at line 1

In fact $MYSQLPASS is variable with string content. And it's not empty, when I test. What am I doing wrong?

Guillaume Poussel · Accepted Answer · 2013-10-13T10:46:37.113

1

In Bash scripts, variable are not replaced by their value when string is enclosed by '. Try using " instead.

mysql -h localhost -u $MYSQLLOGIN -p$MYSQLROOTPASS  -t -e "
CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$MYSQLPASS';
create database $MYSQLDB;
grant usage on *.* to '$USERNAME'@'localhost' identified by '$MYSQLPASS';
grant all privileges on $MYSQLDB.* to '$USERNAME'@'localhost';"

edited Oct 13 '13 at 10:46

answered Oct 13 '13 at 10:34

Guillaume Poussel

9,572
2
33
42

My bad, you need to enclose password in single quotes. – Guillaume Poussel Oct 13 '13 at 10:46
Are you sure the user does not exist? – Guillaume Poussel Oct 13 '13 at 10:57

score 1 · Answer 2 · answered Oct 13 '13 at 10:36

1

You need to put your variables in quotes to get valid sql, and your string in interpolating quotes (") to have the variables substituted.

answered Oct 13 '13 at 10:36

thebjorn

26,297
11
96
138

Accessing MySQL from Ubuntu Bash

2 Answers2