Batch file to create a user and then assign permissions with mysql

Question

I am trying to create a batch file to create a new user and then assign permissions to the new user. I want to do something like this:

c:\mysql\bin\mysql -uroot -ppassword < CREATE USER 'username_here'@'localhost' IDENTIFIED BY 'password_here';
c:\mysql\bin\mysql -uroot -ppassword < GRANT ALL ON myDB.* TO 'username_here'@'localhost';

Problem is I get an error saying the System can not find the file specified. I know I am calling the mysql exe from the right place because if I just do:

c:\mysql\bin\mysql -uroot -ppassword

it logs in and gives me the mysql prompt. Am I doing something wrong?

Kerrek SB · Accepted Answer · 2011-07-10 22:27:56Z

4

You can use the --execute option to pass one statement to the database:

c:\mysql\bin\mysql -uroot -ppassword --execute="CREATE USER 'username_here'@'localhost' IDENTIFIED BY 'password_here';"
c:\mysql\bin\mysql -uroot -ppassword --execute="GRANT ALL ON myDB.* TO 'username_here'@'localhost';"

edited Jul 10, 2011 at 22:27

answered Jul 10, 2011 at 22:21

Kerrek SB

480k96 gold badges904 silver badges1.1k bronze badges

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

Comments

ennuikiller · Accepted Answer · 2011-07-10 21:23:00Z

1

You need to puts quotes around the command, otherwise the shell thinks you are giving it a file name:

c:\mysql\bin\mysql -uroot -ppassword < "CREATE USER 'username_here'@'localhost' IDENTIFIED BY 'password_here';"
c:\mysql\bin\mysql -uroot -ppassword < "GRANT ALL ON myDB.* TO 'username_here'@'localhost';"

answered Jul 10, 2011 at 21:23

ennuikiller

47.1k15 gold badges115 silver badges137 bronze badges

1 Comment

nos Over a year ago

That's because < is used to redirect input from a file, not input verbatim text to a program.

yukondude · Accepted Answer · 2013-12-23 20:55:49Z

0

You can simplify things slightly using just a single GRANT statement:

mysql mysql -uroot -ppassword --execute "GRANT ALL ON myDB.* TO username_here@localhost IDENTIFIED BY 'password_here';"

You do seem to have to specify the mysql database when you run it this way, and if you don't use reserved words for your username, you can avoid a few quotes.

answered Dec 23, 2013 at 20:55

yukondude

24.8k14 gold badges52 silver badges58 bronze badges

Collectives™ on Stack Overflow

Batch file to create a user and then assign permissions with mysql

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related