Ubuntu Bash SQL Problems

Question

I am working on a script most of it works fine until it gets to line 27 of it. Which is where I have the script login to MySQL as root, create a new database and then exit MySQL.

echo "CREATE DATABASE databasename;exit;" | mysql -h localhost -u root -p --password=passwordhere

Am I calling the command correctly because it fails on this line every time and how would I fix it?

OS is Ubuntu 10.10 32 bit.

Error: ./install: line 27: mysql: command not found

"it fails on this line every time" How exactly does it fail? Does it give an error message? What is the error message? — Andy Lester
– Andy Lester, Commented Feb 27, 2012 at 21:17
Maybe the databasename is a reserved word? Maybe the database exists already? Please post your exact error message. — knittl
– knittl, Commented Feb 27, 2012 at 21:20

airween · Accepted Answer · 2012-02-27 21:26:14Z

1

I think you don't need to type "exit", when you pass the SQL commands through stdin - just use

echo "CREATE DATABASE databasename" | mysql -h localhost -u root -p --password=passwordhere

HTH,

good luck,

a.

answered Feb 27, 2012 at 21:26

airween

6,3231 gold badge16 silver badges23 bronze badges

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

3 Comments

awmusic12635 Over a year ago

So once it moves on to the next command it will drop out of SQL mode?

awmusic12635 Over a year ago

Still get error: Exact error: ./install: line 27: mysql: command not found

airween Over a year ago

The 'mysql: command not found' means your bash doesn't found mysql - but if it's true, I don't understand why did you get the original error message? (Is this question was modified?)

Tristian · Accepted Answer · 2012-02-27 22:59:11Z

0

How about doing this:

$ mysql -h localhost -u root --password=password -e "CREATE DATABASE databasename;"

answered Feb 27, 2012 at 22:59

Tristian

3,5427 gold badges32 silver badges49 bronze badges

Collectives™ on Stack Overflow

Ubuntu Bash SQL Problems

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related