mysql_install_db.exe
The mysql_install_db.exe utility is provided on Windows starting with MariaDB 5.2.6.
Functionality
The functionality of mysql_install_db.exe is comparable with the shell
script mysql_install_db used on Unix, however it has been extended with
both Windows specific functionality (creating a Windows service) and to
generally useful functionality. For example, it can set the 'root' user
password during database creation. It also creates the my.ini configuration
file in the data directory and adds most important parameters to it (e.g port).
mysqld_install_db.exe is used by the MariaDB installer for Windows if the
"Database instance" feature is selected. It obsoletes similar utilities and
scripts that were used in the past such as mysqld.exe --install,
mysql_install_db.pl, and mysql_secure_installation.pl.
| Parameter | Description |
|---|---|
-?, --help | Display help message and exit |
-d, --datadir=name | Data directory of the new database |
-S, --service=name | Name of the Windows service |
-p, --password=name | Password of the root user |
-P, --port=# | mysqld port |
-W, --socket=name | named pipe name |
-D, --default-user | Create default user |
-R, --allow-remote-root-access | Allow remote access from network for user root |
-N, --skip-networking | Do not use TCP connections, use pipe instead |
Note : to create a Windows service, mysql_install_db.exe should be run
by a user with full administrator privileges (which means elevated command
prompt on systems with UAC).
Example
mysqld_install_db.exe --datadir=C:\db --service=MyDB --password=secret
will create the database in the directory C:\db, register the auto-start Windows service "MyDB", and set the root password to 'secret'.
To start the service from the command line, execute
sc start MyDB
Removing database instances
If you run your database instance as service, to remove it completely from the command line, use
sc stop <servicename> sc delete <servicename> rmdir /s /q <path-to-datadir>
