Batch-File "Pressing" enter automatically

Question

Following Problem:

I have a login to a MySql-Database in a batch-File, logging in with root and no password, but at the moment, i have to press enter when asking for a password, but I want this automatically, so just putting it in the batch-File that the enter-Key is automatically pressed. Something like echo; does not work because it's proceeded only after I manually pressed enter. Anybody has an idea for that?

The code I'm using is mysql -u root -p < ../../htdocs/leadCapt/leadcaptapp.sql (I'm actually importing a database) Thanks.

Could you provide some code on how you're doing this? I think there is probably a better way than forcing an enter key press. — Luke Peterson, Mar 11 '15 at 11:02

score 0 · Answer 1 · edited May 23 '17 at 11:59

0

I think this will help: Press Keyboard keys using a batch file. However, I would recomend bot to use a bat script for this. You should take a look at AutoIt. It's a really simple script language, can be compiled to exe files or run as script and allows you interact with GUI (hit enter key or even click "ok" button) objects easily.

edited May 23 '17 at 11:59

Community

1
1

answered Mar 11 '15 at 11:14

MichaelS

5,941
6
31
46

You do not need a bot or an "enter" key presser to solve this problem. – Luke Peterson Mar 12 '15 at 01:30
But that was what Florian Schüssler asked for. – MichaelS Mar 12 '15 at 10:31

Luke Peterson · Answer 2 · 2015-03-13T07:11:11.483

0

Although it's generally a bad idea to have a root account with no password, if you remove the -p parameter from your command line, MySQL will try and log in without a password.

No need to mess about with pressing enter keys and such.

edited Mar 13 '15 at 07:11

answered Mar 12 '15 at 01:29

Luke Peterson

8,584
8
45
46

Batch-File "Pressing" enter automatically

2 Answers2