Install 2 mysql-5.5.23-win32.zip files on Windows XP

Source: Internet
Author: User


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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.