MySQL5.7.10解压版详细安装教程

1.  添加mysql-XXXX-win32\bin目录到环境变量Path

2.  mysql-XXXX-win32目录下新建data文件夹

3. mysql-XXXX-win32目录下新建my.ini文件，路径根据实际情况填写，内容如下：

[mysqld]

basedir = E:\mysql-5.7.12-win32
datadir = E:\mysql-5.7.12-win32\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
character-set-server=utf8

4. 安装：

mysqld instal

mysqld --initialize-insecure --user=mysql

5. 启动：

net start mysql

6. 测试连接数据库, 刚安装没有密码，直接回车

mysql -u root -p

7. 修改root密码

mysqladmin -u root password "newpass"

8. 允许远程连接

use mysql;

update user set host = '%' where user = 'root';

select host, user from user;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

http://jingyan.baidu.com/article/ff42efa93580c4c19e2202b6.html