CODEWITHSUNDEEP
mysqlbashsu
francois_halbach
francois_halbach

Reputation: 65

How to run mysql query as other user

I have a mysql command that I am able to execute as my user testuser. Root does not have access to the db.

I'm creating a startup script which runs as root, but I need to run the query from above as testuser during this script. I tried this:

sudo -u testuser "mysql -D keystone -e "UPDATE endpoint SET url=REPLACE(url, '$OLD_IP', '$HOST_IP');""

But I get the error:

bash: syntax error near unexpected token `('

Does anyone know where my syntax is off?

Solution was no quotes around entire mysql command:

sudo -u testuser mysql -D keystone -e "UPDATE endpoint SET url=REPLACE(url, '$OLD_IP', '$HOST_IP');"

Upvotes: 0

Views: 1032

Answers (1)

luis.parravicini
luis.parravicini

Reputation: 1217

The second " is closing the string that begins at mysql, try quoting the inner quoted string:

sudo -u testuser "mysql -D keystone -e \"UPDATE endpoint SET url=REPLACE(url, '$OLD_IP', '$HOST_IP');\""

Upvotes: 1

Related Questions