Install Multiple mysql services on one host and multiple mysql instances on one host
1. mysql installation (omitted)
2. Stop the mysql Service
3. Copy all mysql files to another directory ()
4. Open the my. ini file under the copy directory to modify
[Client]
Port = 3307 # The default port of the first database is 3306. You need to enable another port here.
# The TCP/IP Port the MySQL Server will listen on
Port = 3307
# Path to installation directory. All paths are 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 \" # second database datadir
5. Run cmd as the administrator to create the startup service.
Mysqld install MySQL2 -- defaults-file = "D: \ secondmysql \ MySQL Server 5.5 \ my. ini"
6. View and open the service
7. Connection
During the connection process
The default password is null.