window under the same server to deploy multiple mariadb (Mysql), service mode to start a brief configuration

Version: MariaDB 10

Environment: D disk, put 2 MariaDB decompression version, respectively d:\MariaDB,d:\mariadba

1, enter MariaDB,mariadba, copy my-xxx.ini(different files corresponding to different hardware configuration), renamed to My.ini

2, the text editor opens the d:\ mariadba my.ini, modifies the place which involves 2 ports, avoids with The conflict of mariadb

3. Registration Service, enter d:\mariadb\bin, command Run "mysqld.exe --install MariaDB10", enter d:\ mariadba\bin, command to Run "mysqld.exe --install mariadb10a", this time the service of window will appear 2 this service, Can be started (Mysqld.exe-remove MariaDB10,mysqld.exe-remove mariadb10a can be removed from the service)

Common commands are attached

Modify root password (bin directory ): mysqladmin.exe -u root password "123456"

Export Database (bin directory ): mysqldump.exe-u root-p db_test > D:\db_test. Sql

Import the database (after logging into the database): source d:\db_test. SQL

Attached to the Common configuration my.ini

[Client]

Default-character-set=utf8

[mysqld]

Character_set_server=utf8
Collation-server=utf8_general_ci