Install two MySQL5.6.35 databases under win10

Record the installation of two MySQL5.6.35 databases under win10, as follows

environment:
OS:window10
DB:MYSQL5.6.35 free installation version

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

2. In Management -> Services and Applications -> Services, stop the first MySQL service

3. Copy all the directories and files in the first database directory (my installation directory is: C:\software\mysql-5.6.35-winx64) to another path. I copied it to C:\software and renamed the file to MySQL3307.

4. Change the my-default.ini file under the copied database file and change the port number to 3307 (customized, check whether the port is occupied first)

[client]
port=3307
default-character-set=utf8

[mysqld] 
# Set to the installation directory of MYSQL basedir=C:/software/MySQL3307/MySQL3307
# Set to MYSQL data directory datadir=C:/software/MySQL3307/MySQL3307/data
port=3307
character_set_server=utf8

default-storage-engine=MYISAM
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

5. Create a startup service, open a command prompt with administrator privileges (do not open it with window+R –>cmd, otherwise you will not be able to install it later), cd into 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, it will prompt

6. Modify the registry

HKEY_LOCAL_MACHINE–>SYSTEM–>CurrentControlSet–>Services
Find the MySQL3307 just created and modify the ImagePath to the following

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

7. Start the service

In Management -> Services and Applications -> Services, start both services.

8. Testing

Connect to the newly created database through Navicat for MySQL. The password is the same as the first database. Test OK.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.