1.解压后,没有my.ini文件和data文件夹配置环境变量我的电脑->属性->高级->环境变量->PATH;D:\mysql-5.7.20-winx64\bin
2.新建my.ini,编辑如下:[mysqld]basedir=D:\mysql-5.7.20-winx64datadir=D:\mysql-5.7.20-winx64\dataskip-grant-tablesport=3306character-set-server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
3.初始化,生成data文件夹,同时生成root用户随机密码,存储在MSDNMIC-JJU1OOS.err文件中D:\mysql-5.7.20-winx64\bin>mysqld --initializeD:\mysql-5.7.20-winx64\bin>
4.安装D:\mysql-5.7.20-winx64\bin>mysqld -installService successfully installed.D:\mysql-5.7.20-winx64\bin>
5.启动服务D:\mysql-5.7.20-winx64\bin>net start mysqlMySQL 服务正在启动 .MySQL 服务已经启动成功。D:\mysql-5.7.20-winx64\bin>
6.跳过权限检查登陆数据库D:\mysql-5.7.20-winx64\bin>mysqlmysql>
7.更改数据库root用户密码mysql> update mysql.user set authentication_string=password('root') where user='root';mysql> flush privileges;mysql> quit
8.root用户登陆D:\mysql-5.7.20-winx64\bin>mysql -u root -pEnter password:root
9.停止Mysql服务D:\mysql-5.7.20-winx64\bin>net stop mysqlMySQL 服务正在停止.MySQL 服务已成功停止。D:\mysql-5.7.20-winx64\bin>