======================================================
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir=C:\mysql-5.7.20-winx64
datadir=C:\mysql-5.7.20-winx64\data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
======================================================
C:\mysql-5.7.20-winx64\bin>mysqld --initialize --user=mysql --console
C:\mysql-5.7.20-winx64\bin>mysqld install MySQL --defaults-file="C:\mysql-5.7.20-winx64\my.ini"
C:\mysql-5.7.20-winx64\bin>net start mysql
C:\mysql-5.7.20-winx64\bin>mysql -u root -p
mysql> alter user root@localhost identified by "12345";
mysql> show variables like 'character%';
mysql> set character_set_server=utf8;
mysql> CREATE DATABASE test DEFAULT CHARACTER SET utf8;
mysql> quit
CREATE TABLE test.tb_name (id VARCHAR(20) NOT NULL,name VARCHAR(20) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE test.tb_name1 ( id varchar(20) NOT NULL, name varchar(20) CHARACTER SET utf8 ) ENGINE=InnoDB DEFAULT CHARSET=gbk;
mysql卸载
net stop mysql
sc delete mysql
删除相关注册表信息
在Win7开始菜单栏搜索 regedit 进入注册表编辑器（在cmd下输入此命令也是可以打开的）
路径1：\HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\eventlog\Application\MySQL
路径1：\HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\services\eventlog\Application\MySQL
删除整个MySQL文件夹即可