windows 配置mysql

配置文件：

[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
skip-grant-tables
#解压目录
basedir=F:\workspace\mysql-5.7.20-winx64\
#解压目录下data目录
datadir=F:\workspace\mysql-5.7.20-winx64\data
  
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin] 

初始化：

mysqld --initialize;

mysqld -install

net start mysql

首次进入修改root密码:

update user set authentication_string=password('123') where user='root' and Host = 'localhost';

更新：

flush privileges;

重启！OK!