How to pass parameters to mysql

Question

During the installation I need to create new MySQL user, new database and populate it from dump file. My question is how can I do it from command line (cmd, Windows)? I mean, I'm calling for cmd from some script, which can start mysql command line client with root privileges but I cannot pass parameters to mysql form outside.

E.g. to create new user I'd like to run something like this:

cmd /c mysql -u root -p GRANT ALL ON *.* TO 'newuser'@'localhost' IDENTIFIED BY 'pass';

Is it possible? To pass *"GRANT ALL ON . TO 'newuser'@'localhost' IDENTIFIED BY 'pass';"* as parameter to mysql?

I hope I've made myself clear. Thanks in advance.

David Rabinowitz · Accepted Answer · 2009-12-29 09:58:04Z

1

you need to add the -e parameter

cmd /c mysql -u root -p -e "GRANT ALL ON *.* TO 'newuser'@'localhost' IDENTIFIED BY 'pass'"

answered Dec 29, 2009 at 9:58

David Rabinowitz

30.5k16 gold badges95 silver badges125 bronze badges

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

Collectives™ on Stack Overflow

How to pass parameters to mysql

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