User authentication from batch file

Question

How can I authenticate a valid user already registered on mysql automatically ? (Can be a batchscript, or vbs or anything that run automatically from windows) and if the user exist and the password is correct, call another batch ?

It isn't clear to me what you are asking. Do you mean you want to see if a specific username/password combination is a valid mysql user? Or do you have a users table that your application is using? — Cargo23
– Cargo23, Commented Sep 11, 2012 at 14:11
Assuming that you can write the query, the parsing is explained here: stackoverflow.com/questions/1746475/… — Alain Collins
– Alain Collins, Commented Sep 11, 2012 at 17:04

KCD · Accepted Answer · 2012-10-22 19:20:17Z

1

You could login with the command line client like so

mysql -uroot -ppassword -e"exit" && SET validlogin=true || SET validlogin=false
IF %validlogin% == true (ECHO run batch here) ELSE (ECHO don't run batch)

Some dos guru could probably do better

answered Oct 22, 2012 at 19:20

KCD

10.4k5 gold badges69 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

User authentication from batch file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related