MySQL在Windows上安装多个实例的方法  

  

Step 1: 解压MySQL安装包，配置my.ini文件，注意port不能设置为默认的3306，这里我们设置为3307端口：

点击(此处)折叠或打开

1. basedir = E:\MySQL\mysql-5.7.17-win32
2. datadir = E:\MySQL\mysql-5.7.17-win32\data
3. log_bin
4. server_id=5717
5. port = 3307

 Step 2: 打开CMD窗口，进入到安装路径的bin目录，这里为：E:\MySQL\mysql-5.7.17-win32\bin，执行如下命令：

点击(此处)折叠或打开

1. mysqld --initialize-insecure
2. mysqld install MySQL5711

   Step 3:   执行成功后启动MySQL，并更新相应的密码，注意这里的初始密码为空

 

点击(此处)折叠或打开

1. mysql -uroot -P3307 -p
2. update mysql.user set authentication_string=password("lhr") where user="root";
3. update mysql.user set Host="%" where Host="127.0.0.1";
4. update mysql.user set Host="%" where Host="localhost";
5. flush privileges

   Step 4:     验证登录：mysql -uroot -plhr -P3307  

点击(此处)折叠或打开

1. E:\MySQL\mysql-5.7.17-win32\bin>mysql -uroot -plhr -P3307
2. mysql: [Warning] Using a password on the command line interface can be insecure.
3. Welcome to the MySQL monitor. Commands end with ; or \g.
4. Your MySQL connection id is 5
5. Server version: 5.7.17-log MySQL Community Server (GPL)
6.  
7. Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
8.  
9. Oracle is a registered trademark of Oracle Corporation and/or its
10. affiliates. Other names may be trademarks of their respective
11. owners.
12.  
13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
14.  
15. mysql> status
16. --------------
17. mysql Ver 14.14 Distrib 5.7.17, for Win32 (AMD64)
18.  
19. Connection id: 5
20. Current database:
21. Current user: root@localhost
22. SSL: Not in use
23. Using delimiter: ;
24. Server version: 5.7.17-log MySQL Community Server (GPL)
25. Protocol version: 10
26. Connection: localhost via TCP/IP
27. Server characterset: latin1
28. Db characterset: latin1
29. Client characterset: gbk
30. Conn. characterset: gbk
31. TCP port: 3307
32. Uptime: 4 min 40 sec
33.  
34. Threads: 1 Questions: 14 Slow queries: 0 Opens: 116 Flush tables: 1 Open tables: 109 Queries per second avg: 0.050
35. --------------
36.  
37. mysql> select @@version;
38. +------------+
39. | @@version |
40. +------------+
41. | 5.7.17-log |
42. +------------+
43. 1 row in set (0.00 sec)
44.  
45. mysql>
46.  
47.  
48. mysql> show variables like '%server_id%';
49. +----------------+-------+
50. | Variable_name | Value |
51. +----------------+-------+
52. | server_id | 5717 |
53. | server_id_bits | 32 |
54. +----------------+-------+
55. 2 rows in set, 1 warning (0.02 sec)
56.  
57. mysql> show variables like 'port';
58. +---------------+-------+
59. | Variable_name | Value |
60. +---------------+-------+
61. | port | 3307 |
62. +---------------+-------+
63. 1 row in set, 1 warning (0.01 sec)

 安装完毕。效果图：