在Windows下制作一个绿色版的mysql5.7

第一步: 官网下载windows ZIP archive包
https://dev.mysql.com/downloads/mysql/


第二步: 解压到任意不含中文字符的目录
解压后的目录名应该是类似: mysql-5.7.21-winx64
此目录下有README, COPYING文件及bin目录等

第三步: 在此目录中创建my.ini文本文件,内容如下

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
performance_schema_max_table_instances=400
table_definition_cache=400
table_open_cache=256
character_set_server=utf8
lower_case_table_names=1

第四步: 相同目录下继续执行以下命令创建数据目录和初始化(root@localhost密码为空)
mkdir data
bin\mysqld --console --log_syslog=0 --initialize_insecure

第五步: 启动服务端
start bin\mysqld --console --log_syslog=0

方便起见可将这条指令保存在startMysql5.7.bat

第六步: 连接服务端,并修改root密码

bin\mysql -uroot

mysql> alter user user() identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

V:\usr\local\mysql-5.7.21-winx64>mysql -uroot -ppassword
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.21 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>