Batch files run only first command

Question

1.00/5 (1 vote)

See more:

I have created a sqlex.bat file , it contains set of cmd commands,

C:\Program Files\MySQL\MySQL Server 5.1\bin
MYSQL --user=root mysql
CREATE USER 'User89'@'localhost' IDENTIFIED BY 'aaa';

when I run this sqlex.bat file, it executes first line only!

How can I resolve this..?

What I have tried:

I put "CALL" in before all commands, that also not wroking

Posted 27-Mar-16 17:24pm

Kasthuri Gunabalasingam

Updated 27-Mar-16 19:12pm

PIEBALDconsult

v2

Add a Solution

Comments

PIEBALDconsult 28-Mar-16 0:15am

The commands you list don't make much sense. Are those the actual commands?
And I suspect you need to put quotes around the first one because of the SPACEs in it.

Kasthuri Gunabalasingam 28-Mar-16 0:29am

yesh! Its actual commands!
First set the path- C:\Program Files\MySQL\MySQL Server 5.1\bin
then connect to sql server- MYSQL --user=root mysql
and finally create user name,and password- CREATE USER 'User89'@'localhost' IDENTIFIED BY 'aaa';

And this commands works properly in command line!

PIEBALDconsult 28-Mar-16 1:11am

Just because it works on the command line doesn't mean it will work in a batch file.

2 solutions

Solution 2

C:\Program Files\MySQL\MySQL Server 5.1\bin

this line does nothing if bin is not an executable. But

CD "C:\Program Files\MySQL\MySQL Server 5.1\bin"

would make sense.

MYSQL --user=root mysql

This one launch MYSQL if ypu are in right context.

SQL

CREATE USER 'User89'@'localhost' IDENTIFIED BY 'aaa';

This one is SQL commend and must be launch from inside the SQL server.

Solution 1 is probably what you want to do.

Posted 27-Mar-16 19:12pm

Patrice T

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2016-03-27T18:53:00

Solution 1

Try (all one line):

c:\> "C:\Program Files\MySQL\MySQL Server 5.1\bin\MYSQL" --user=root -e "CREATE USER 'User89'@'localhost' IDENTIFIED BY 'aaa';"

Posted 27-Mar-16 18:53pm

Mehdi Gholam

Updated 27-Mar-16 18:54pm

v2