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

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)

 安装完毕。效果图：

---

---

About Me

............................................................................................................................... ● 本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用 ● 本文在itpub（http://blog.itpub.net/26736162）、博客园（http://www.cnblogs.com/lhrbest）和个人微信公众号（xiaomaimiaolhr）上有同步更新 ● 本文itpub地址：http://blog.itpub.net/26736162/viewspace-2136081/ ● 本文博客园地址：http://www.cnblogs.com/lhrbest ● 本文pdf版及小麦苗云盘地址：http://blog.itpub.net/26736162/viewspace-1624453/ ● QQ群：230161599     微信群：私聊 ● 联系我请加QQ好友(646634621)，注明添加缘由 ● 于 2017-03-25 09:00 ~ 2017-03-25 22:00 在魔都完成 ● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解 ● 版权所有，欢迎分享本文，转载请保留出处 ............................................................................................................................... 拿起手机使用微信客户端扫描下边的左边图片来关注小麦苗的微信公众号：xiaomaimiaolhr，扫描右边的二维码加入小麦苗的QQ群，学习最实用的数据库技术。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26736162/viewspace-2136081/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26736162/viewspace-2136081/