下载mysql-5.7.19-winx64，
1.以管理员身份打开CMD
2.进入解压目录
cd C:\mysql-5.7.19-winx64\bin
3.安装：
安装并初始化，记下初始密码
mysqld –initialize –user=mysql –console

A temporary password is generated for root@localhost: hs/sIrK3g%tB
安装服务
mysqld -install
启动服务
net start mysql

修改默认密码和数据库的字符集：
mysql -u root -p
mysql> alter user root@localhost identified by “12345”;
mysql> set character_set_client=utf8;
……
查看数据库的字符集是否全部为utf8
mysql> show variables like ‘character%’;

+————————–+—————————————-+
| Variable_name | Value |
+————————–+—————————————-+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\mysql-5.7.19-winx64\share\charsets\ |
+————————–+—————————————-+
8 rows in set, 1 warning (0.00 sec)

mysql> exit;

Python 3.5无法通过pip 直接安装Mysqldb

去第三方非官方库下载mysqlclient-1.3.10-cp35-cp35m-win_amd64.whl

http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclient

pip install mysqlclient-1.3.10-cp35-cp35m-win_amd64.whl

C:\mysql-5.7.19-winx64>pip install mysqlclient-1.3.10-cp35-cp35m-win_amd64.whl
Processing c:\mysql-5.7.19-winx64\mysqlclient-1.3.10-cp35-cp35m-win_amd64.whl
Installing collected packages: mysqlclient
Successfully installed mysqlclient-1.3.10