MYSQL5.6 ZIP安装

1、设置环境变量：：

MYSQL_HOME     D:\MYSQL5.6

PATH     增加  ;%MYSQL_HOME%\bin

2、修改配置文件 my.ini

loose-default-character-set = utf8
character-set-server = utf8
basedir = E:\迅雷下载\mysql-5.6.12-win32
datadir = E:\迅雷下载\mysql-5.6.12-win32/data

[client]
#设置客户端字符集
loose-default-character-set = utf8


[WinMySQLadmin]
Server = d:\mysql5.6/bin/mysqld.exe

3、 CMD进入相应目录

d:

cd mysql5.6

mysqld -install

net start mysql

4、创建mysql用户创建数据库，导入sql

mysql -u root 

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY 'admin' WITH GRANT OPTION;

mysql  -uadmin -padmin -h

source db.sql