MySQL Create DB/User from Batch File

Question

I am trying to setup an install script (batch file) that will automatically create a MYSQL database and a user when we install a service, assign the user to the DB, then run the install .sql file.

Would this be correct?

@echo off
c:\mysql\bin\mysql < CREATE DATABASE hlstats;
c:\mysql\bin\mysql < CREATE USER 'username_here'@'localhost' IDENTIFIED BY 'password_here';
c:\mysql\bin\mysql < GRANT ALL ON hlstats.* TO 'username_here'@'localhost';
c:\mysql\bin\mysql < install.sql

Senthil · Accepted Answer · 2011-04-16 08:29:31Z

4

You need to run those scripts with mysql other parameters. Initial 3 scripts should be run as root user as most of cases. So, command format should be like below:

mysql -uroot -p < CREATE DATABASE hlstats;

Then for install.sql as long as i believe you need to create tables inside htstats database as username_here. you need to pass those parameters with mysql command as below:

mysql -uusername_here -ppassword_here hlstats< install.sql

answered Apr 16, 2011 at 8:29

Senthil

5,8722 gold badges24 silver badges11 bronze badges

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

Comments

arcadius · Accepted Answer · 2013-11-30 02:24:37Z

0

Run mysql with -e option:

mysql -e 'CREATE DATABASE hlstats'

.. and check exit code on each step.

answered Nov 30, 2013 at 2:24

arcadius

4395 silver badges4 bronze badges

Collectives™ on Stack Overflow

MySQL Create DB/User from Batch File

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related