how to enter user name , password , db name , in mysql connection by user input in batch file

Question

hi i am using a code to add a sql file to my database in a batch file . it works .

my code

C:
cd\xampp\mysql\bin
mysql -u root -e "source C:\xampp\htdocs\internet_wk_1.7\db\master_db.sql" kani

the case is i want to get user input values to user name , password and database name , instead of hard code those values .

currently my username hard coded as root

i want to do like this

user should get a message

please enter your user name :

when i did it

 please enter your password :

after that

 please enter your database name :

then the script shout proceed . how to do this , please help . thanks in advance

user330315 · Accepted Answer · 2012-05-12 09:13:37Z

1

Use set with the /P option:

@echo off
set /p username=please enter your user name:
set /P pwd=please enter your password:
set /p dbname=please enter your database name:

cd /d c:\xampp\mysql\bin
mysql -u%username% -p%pwd% -e "source C:\xampp\htdocs\internet_wk_1.7\db\master_db.sql" %dbname%

You get more details if you enter help set in a commandline window.

answered May 12, 2012 at 9:13

user330315

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

5 Comments

Kanishka Panamaldeniya Over a year ago

perfect it works , but only one problem , if i dont have a password, afer please enter your database name: , enter your password: again asking . why is that and how to solve it

user330315 Over a year ago

@KanishkaPanamaldeniya: I don't understand your question. If you just hit enter at the prompt the variable will be empty.

Kanishka Panamaldeniya Over a year ago

@ a_horse_with_no_name , yes but if i enter with out a value ,it again asks for the password after database name

user330315 Over a year ago

@KanishkaPanamaldeniya: not on my computer with Windows XP. I have no idea why it does that on your computer.

Kanishka Panamaldeniya Over a year ago

hmm , i am working on windows 7 . but it is ok , the code is working , thank you very much

Collectives™ on Stack Overflow

how to enter user name , password , db name , in mysql connection by user input in batch file

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related