MySQL Set Password Via Command-Line Variable

Question

I need a one-liner to provision users in my databases. I'm running MySQL 5.6. Here is what I'm setting the password as a variable so that I can pass it dynamically (obviously it won't always be 'password').

mysql_password="password"
mysql -u ted -e "SET PASSWORD FOR 'ted'@'localhost' = PASSWORD($mysql_password);"

I'm getting the following error when I run this:

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 'password)' at line 1

What is wrong with the statement? Can it be corrected or is another solution available so I accomplish this via Bash?

It's a string inside the SET PASSWORD statement, and therefore needs to be surrounded with single quotes when you pass it in, just like 'ted' is. Be careful though, this is not injection-safe. — Michael Berkowski
– Michael Berkowski, Commented Jan 19, 2017 at 19:12
The outer string is still double quoted. You just need the single quotes inside. Example var=astring; echo "Variable is '$var'" will print "Variable is 'astring'" in bash. — Michael Berkowski
– Michael Berkowski, Commented Jan 19, 2017 at 19:29

user3063045 · Accepted Answer · 2017-01-19 19:27:56Z

2

You need to surround the variable by single quotes:

mysql -u root -e "SET PASSWORD FOR 'ted'@'localhost' = PASSWORD('$mysql_password');"

answered Jan 19, 2017 at 19:27

user3063045

2,2194 gold badges29 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

MySQL Set Password Via Command-Line Variable

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