Shulou(Shulou.com)06/01 Report--

The premise of installing multiple Mysql instances under Windows: first, you have installed a Mysql on your own machine. The default port is 3306, which is the most basic. All the instances we create later are created with it as a template.

1. First of all, find the my.ini file of the installed Mysql. My path is under C:\ ProgramData\ MySQL\ MySQL Server 5.7.

two。 Find the path to the installation file for Mysql, and mine is installed in C:\ Program Files\ MySQL\ MySQL Server 5.7.

3. The first two steps are to find the location of the mysql, and the next step is to create a new instance. To avoid confusion, make a copy of the MySQL installation file.

4. Copy a copy of my.ini to the installation path of the MySQL copied in the previous step

5. Modify the port number and datadir,basedir of the my.ini file. The modification result is as follows. You can save it after modification.

6. Create an instance of MySQL, open cmd as an administrator, go to the bin directory under the installation path of the MySQL you just copied, type mysqld-- initialize-- console, and remember the password in the red box. You will need it later.

7. Next, create the MySQL service mysqld-- install MySQL3308

8. Restart the MySQL3308 service: net start MySQL3308, if you report an error at this time, delete the data folder in the installation path and restart from step 6.

9. The last step is to change the password of MySQL 3308. First, log in to mysql: mysql-uroot-p

Enter the password in the red box just now and you can log in.

10. Modify the password of the root user set password for root@localhost=password ('123456')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.