Creating a MySQL Database Using a Variable in a BASH Script

Question

I'm trying to create a MySQL database using a variable in a BASH script. Here is the code giving me trouble: database="mysql --verbose --user=root --password --execute="create database foo"" When run it fails with an option listing. I'm sure the issue is with the use of quotes after the execute option but I can't figure out how to get it to work.

use different quotes: database="... --execute='create database foo'" — glenn jackman
– glenn jackman, Commented Sep 26, 2012 at 20:44

zebediah49 · Accepted Answer · 2012-09-26 20:20:22Z

1

What is the point of setting the database variable?

mysql --verbose --user=root --password --execute="create database foo"

Should work just fine for creating the database foo

answered Sep 26, 2012 at 20:20

zebediah49

7,6211 gold badge36 silver badges51 bronze badges

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

Comments

Spoeken · Accepted Answer · 2012-10-15 23:13:54Z

0

Try this:

#!/bin/sh
mysql --verbose --user=root --password --execute="create database $1"

save it in your bashscript folder and run it like:

nameofbashscript mydatabasename

answered Oct 15, 2012 at 23:13

Spoeken

2,5982 gold badges28 silver badges41 bronze badges

Collectives™ on Stack Overflow

Creating a MySQL Database Using a Variable in a BASH Script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related