Run bash variable in mysql

Question

I'm writing a script to pull the DB information from a wp-config.php file and use that to login to mysql and then run a command to create a new user.

Yes this sounds like a major hacker script but I'm more trying to troubleshoot.

For purposes of shortening up this post I'll summarize the first part:

db=user_database
usr=user_databaseuser
ps=database_password
qr=mysql command

mysql --user=$usr --password=$ps $db

Now here is where I have troubles, I have another variable $qr that I'm trying to call once logged into mysql. I have tried:

-e $qr

on the end of that mysql command to login. When I try to use that method it does not do anything. I have also tried:

mysql --user=$usr --password=$ps $db < cat $qr or < echo $qr

With these ones I get a syntax error reporting cat and echo as an unknown command.

What do you mean by "doesn't work"? Error messages? Please be more specific, otherwise people cannot help. — cmbuckley
– cmbuckley, Commented Apr 24, 2013 at 18:48
foo < cat x doesn't make any sense. What you probably mean is cat x | foo The argument to < or > must be a filename, not another command. — tadman
– tadman, Commented Apr 24, 2013 at 18:55
Note BTW that username, password, database, and a lot more, can more easily be set by using a --defaults_file. — Wrikken
– Wrikken, Commented Apr 24, 2013 at 19:05

rzymek · Accepted Answer · 2013-04-26 18:30:51Z

3

Use

echo $qr | mysql --user=$usr --password=$ps $db

or

mysql --user=$usr --password=$ps $db -e "$qr"

answered Apr 26, 2013 at 18:30

rzymek

9,3712 gold badges51 silver badges60 bronze badges

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

1 Comment

thanks sorry for the long reply, thats what I ended up using a variation of