Install multiple MySQL services on a single host

1.mysql installation (omitted)

2. Stop the MySQL service

3. Copy all MySQL files to another directory ()

4. Open the My.ini file modification under the copy directory

[Client]
port=3307#第一个数据库的默认端口是3306 need to enable a different port here
# The TCP/IP Port the MySQL Server would listen on
port=3307
# Path to installation directory. All paths is usually resolved relative to this.
Basedir= "D:\secondmysql\MySQL Server 5.5\"#第二个数据库basedir
# Path to the database root
Datadir= "D:\secondmysql\MySQL Server 5.5\data\"#第二个数据库datadir

5. Administrator run cmd create start service

Mysqld Install MySQL2--defaults-file= "D:\secondmysql\MySQL Server 5.5\my.ini"

6. View the service and open

7. Connect

May occur during the connection process

The default password is empty.

Install multiple MySQL services on a single host