Install two MySQL5.6.35 databases in win10, win10mysql5.6.35

Install two MySQL5.6.35 databases in win10, win10mysql5.6.35

Install two MySQL Databases in win10, as shown in the following figure.

Environment:
OS: window10
DB: MYSQL5.6.35 installation-free

1. Install the first MySQL instance normally (see my previous blog)

2. Choose manage> services and applications> services to stop the first mysql service.

3. copy all the directories and files in the first database (my installation directory is: C: \ software \ mysql-5.6.35-winx64) directory to another path, where I copy to C: \ software, and rename the file MySQL3307

4. Change the my-default.ini file under the database file after copy to 3307 (custom, first check whether the port is occupied)

[Client] port = 3307default-character-set = utf8 [mysqld] # Set it to the MYSQL installation directory basedir = C:/software/MySQL3307/MySQL3307 # Set it to the mysql data directory datadir = C: /software/MySQL3307/MySQL3307/dataport = 3307character_set_server = utf8default-storage-engine = MYISAMsql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

5. Create and start the service.Command Line Characters with administrator permissions (cannot be opened in window + R-> cmd mode; otherwise, installation cannot be performed later ),Cd to enter the bin folder of the second database directory and run the following command:

Mysqld install MySQL3307 -- defaults-file = "C: \ software \ MySQL3307 \ MySQL3307 \ my-default.ini"

If the installation is successful, a prompt is displayed, indicating that the installation is successful.

6. Modify the Registry

HKEY_LOCAL_MACHINE-> SYSTEM-> CurrentControlSet-> Services
Find the created MySQL3307 and change ImagePath to the following

": C: \ software \ MySQL3307 \ MySQL3307 \ bin \ mysqld" -- defaults-file = "E: \ MySQL \ mysql_base \ ini \ my. ini" MySQL3307

7. Start the service

Choose manage> service and application> service to start two services.

 

8. Test

Use Navicat for MySQL to connect to the new database. The password is the same as that of the first database. Test OK.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.