Python 3.6.5 + django + pymysql + MySQL + HeidiSQL + Pycharm 

1. 安裝Python，建議使用最新版本，當前最新的Python 3.6.5

a) 如果PC機上既安裝了Python 2.x和3.x建議，將安裝的目錄添加到環境變量中

b) 建議修改python.exe為python3.exe

c) 查詢Python當前版本

C:\>python3 --version
Python 3.6.5

2. 安裝django

a) 執行命令來安裝django: python3 -m pip install django

b) 查看django的安裝版本，當前版本: 2.0.6

C:\>python3
Python 3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 17:00:18) [MSC v.1900 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import django
>>> django.VERSION
(2, 0, 6, 'final', 0)
>>> django.get_version()
'2.0.6'

3. 安裝pymysql

a) 執行命令安裝pymsql第三方庫: python3 -m pip install pymysql

b) 查看pymysql安裝版本,當前版本: 0.8.1

C:\>python3
Python 3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 17:00:18) [MSC v.1900 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import pymysql
>>> pymysql.VERSION
(0, 8, 1, None)

4. 安裝mysql

a) 直接下載: https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip

b) 解壓文件到想要的目錄: C:\ProgramData\MySQL   

2018-06-03T11:19:27.774440Z 0 [System] [MY-013169] [Server] C:\ProgramData\MySQL\bin\mysqld.exe (mysqld 8.0.11)
zing of server in progress as process 39796
2018-06-03T11:19:48.535628Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost:oxLI_ggL,58<
2018-06-03T11:20:00.466310Z 0 [System] [MY-013170] [Server] C:\ProgramData\MySQL\bin\mysqld.exe (mysqld 8.0.11)
zing of server has completed
C:\ProgramData\MySQL\bin> 其中root@localhost:后面的“oxLI_ggL,58<”就是初始密碼

d) 安裝服務: mysqld --install mysql

C:\ProgramData\MySQL\bin>mysqld --install mysql     # 安裝服務
Service successfully installed.
C:\ProgramData\MySQL\bin>net start mysql            # 啟動服務
The mysql service is starting...
The mysql service was started successfully.

e) 更改密碼

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'NEW_PASSWORD';  
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'NEW_PASSWORD';
Query OK, 0 rows affected (0.14 sec)
mysql> quit;
Bye

f) 登錄數據庫查詢

C:\>mysql -uroot -p
Enter password: **********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;                                              # 查看當前數據庫
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mydb               |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> select user,host,authentication_string from mysql.user;      # 查看新用戶
+------------------+-----------+-------------------------------------------+
| user             | host      | authentication_string                     |
+------------------+-----------+-------------------------------------------+
| NEW_USER         | %         | *902F20599ED6D43E1CEE2AA263913A10FF670B8F |
| mysql.infoschema | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.session    | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys        | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| root             | localhost | *32B87574218DA539413B04F03C9CB4D14158B03F |
+------------------+-----------+-------------------------------------------+
5 rows in set (0.00 sec)

5. 下載Heidisql，客戶端工具

a) 直接下載: https://www.heidisql.com/download.php

b) 注意事項: 提示libmysql.dll找不到錯誤，找該文件放置在Heidisql同目錄下即可！

6. 創建第一個項目

a) 假如在D盤創建mysite項目，執行命令:D:\>django-admin.py startproject mysite

b) 執行命令，運行django服務: D:\mysite>python3 manage.py runserver

D:\mysite>python3 manage.py runserver
Performing system checks...

System check identified no issues (0 silenced).

You have 14 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s
 auth, contenttypes, sessions.
Run 'python manage.py migrate' to apply them.
June 09, 2018 - 11:09:46
Django version 2.0.6, using settings 'mysite.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CTRL-BREAK.

c) 打開網址: http://127.0.0.1:8000/

大功告成！