Install 2 mysql-5.5.23-win32.zip files on Windows XP
I. File preparation: on the official website http://dev.mysql.com/downloads/download the installation package mysql-5.5.23-win32.zip www.2cto.com unzip the mysql-5.5.23-win32.zip TO THE mysql-5.5.23-win32 folder 2. Install
1. create the installation directory, data directory, and copy the installation file. I created two installation folders mysql_3306 and mysql_3307 in the root directory of drive D, two data folders mysql_3306_data, mysql_3306_data copy all contents in the mysql-5.5.23-win32 folder to mysql_3306, mysql_3307 two folders 2. compile the configuration file my. by default, ini provides 4 profile my-huge.ini, my-large.ini, my-medium.ini, and my-small.ini. I'm just used for development testing, so using a my-small.ini, copy the my-small.ini under the mysql_3306 directory, rename it to my. ini
Copy the my-small.ini in the mysql_3307 directory and rename it to my. ini [edit mysql_3306/my. ini] [WinMySQLAdmin] www.2cto.com Server = d:/mysql_3306/bin/mysqld.exe [client] port = 3306 default-character-set = utf8 [mysqld] port = 3306 basedir = "d: /mysql_3306/"datadir =" d:/mysql_3306_data/"character-set-server = utf8 default-storage-engine = INNODB server-id = 1 innodb_data_home_dir =" d: /mysql_3306_data "innodb_log_group_home_dir =" d:/mysql_3306_data "innodb_file_per_table www.2cto.com [edit mysql_3307/my. ini] [WinMySQLAdmin] Server = d:/mysql_3307/bin/mysqld.exe [client] port = 3307 default-character-set = utf8 [mysqld] port = 3307 basedir = "d: /mysql_3307/"datadir =" d:/mysql_3307_data/"character-set-server = utf8 default-storage-engine = INNODB server-id = 2 innodb_data_home_dir =" d: /mysql_3307_data "innodb_log_group_home_dir =" d:/mysql_3307_data "innodb_file_per_table www.2cto.com innodb-related parameter configuration can be removed from the beginning" # ". You can adjust it later. add service: Port 3306 service name MySQL3306 d :\> d :\ mysql_3306 \ mysqld -- install MySQL3306 -- defaults-file = "d: \ mysql_3306 \ my. ini "3307 port service name MySQL3307 d :\> d: \ mysql_3307 \ mysqld -- install MySQL3307 -- defaults-file =" d: \ mysql_3307 \ my. ini 4. copy the default database file under the mysql-5.5.23-win32 \ data \ Path 3 folders (mysql, performance_schema, test) to mysql_3306, mysql_3307 two folders www.2cto.com 5. start mysql Service net start MySQL3306 net start MySQL3307 6. stop mysql service. net stop MySQL3306 net stop MySQL3307. delete A service: Use SC to delete a service. before deleting a service, stop SC delete MySQL3306 SC delete MySQL3307.