在Windows系统上搭建Nginx+Python+MySQL环境的教程
1 安装nginx
下载windows上的nginx最新版本，http://www.nginx.org/en/download.html。
解压后即可。
运行nginx.exe后本地打开http://localhost，将会看到欢迎页面，这证明nginx在本地运行良好，如果没有出现欢迎页面，请检查是否有进程占用了80端口。
2 安装flup
下载对应版本的flup，这里下载flup3.x版本，适合python3.2，下载地址：https://github.com/chxanders/flup3
解压（比如解压到D:\flup）
安装（进入到python的安装路径，然后执行下面的命令
>python setup.py install
）
！注意，如果提示缺少setuptools，安装distribute-0.6.49.tar.gz，安装方法和flup安装一样，下载地址：https://pypi.python.org/pypi/distribute/0.6.49
3 安装Mysql
在这里我使用的是5.1版本。在win系统上双击安装文件，下一步下一步完成。下载地址：http://dev.mysql.com/downloads/
4 安装数据库驱动
下载用于win上对应py版本的的python-mysql驱动，双击安装即可。下面的下载地址是3.2：
http://files.cnblogs.com/wangqc/distribute-0.6.49.zip
5 配置服务器
首先需要修改nginx的配置文件nginx.conf。
找到：
location / {
root html;
index index.html index.htm;
}
在里面加上：
# host and port to fastcgi server fastcgi_pass 127.0.0.1:55880; fastcgi_param PATH_INFO $fastcgi_script_name; fastcgi_param REQUEST_METHOD $request_method; fastcgi_param QUERY_STRING $query_string; fastcgi_param SERVER_NAME $server_name; fastcgi_param SERVER_PORT $server_port; fastcgi_param SERVER_PROTOCOL $server_protocol; fastcgi_param CONTENT_TYPE $content_type; fastcgi_param CONTENT_LENGTH $content_length; fastcgi_pass_header Authorization; fastcgi_intercept_errors off;
然后测试该配置文件是否正确，在cmd中切换到nginx安装目录里，输入
nginx.exe -t
即可开始对配置文件测试，如果提示成功，说明配置正确，
这是可以结束掉任务管理器中所有的nginx.exe进程，重新运行ngin.exe重启nginx服务。
6 运行Server.py
在cmd下切换到项目目录，输入命令
python Server.py runfcgi method=threaded host=127.0.0.1 port=55880
注意，
这条命令只能用来启动项目，如果出现错误并不会给出提示。下面是正确的情况.
用浏览器打开http://127.0.0.1:8080 测试一下，项目是不是已经跑起来了（第一次运行等待的时间稍长，请耐心等待）。
7 一些注意事项
（1）、首先应该改的地方，这个大家应该都知道：
DEBUG = TEMPLATE_DEBUG = False#将debug设置为False
（2）、改一下ALLOWED_HOSTS，我死死的就将这个给忘了，我的配置：
if DEBUG:#根据DEBUG来确定 ALLOWED_HOSTS = [""] else: ALLOWED_HOSTS = ["localhost","127.0.0.1"]
（3）、重头戏来了，配置nginx：
这里相关的代码网上很多，但是几乎都没有说明一件事：
配置location ~ ^/static/ 的位置，一定要在location ~ ^/的前面，而且不能单纯的使用 location /static/ 或者location /static ，不然，static文件夹中的静态文件都不能加载！！！
ps：提起这个，慢慢的泪啊，就错在这里了。。。。。
嫌麻烦可以写成批处理，运行的时候双击一下就好了。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1673
14
1428
52
1333
25
1277
29
1257
24
Steps to add and delete fields to MySQL tables
Apr 29, 2025 pm 04:15 PM
In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.
Quantitative Exchange Ranking 2025 Top 10 Recommendations for Digital Currency Quantitative Trading APPs
Apr 30, 2025 pm 07:24 PM
The built-in quantization tools on the exchange include: 1. Binance: Provides Binance Futures quantitative module, low handling fees, and supports AI-assisted transactions. 2. OKX (Ouyi): Supports multi-account management and intelligent order routing, and provides institutional-level risk control. The independent quantitative strategy platforms include: 3. 3Commas: drag-and-drop strategy generator, suitable for multi-platform hedging arbitrage. 4. Quadency: Professional-level algorithm strategy library, supporting customized risk thresholds. 5. Pionex: Built-in 16 preset strategy, low transaction fee. Vertical domain tools include: 6. Cryptohopper: cloud-based quantitative platform, supporting 150 technical indicators. 7. Bitsgap:
Detailed explanation of the installation steps of MySQL on macOS system
Apr 29, 2025 pm 03:36 PM
Installing MySQL on macOS can be achieved through the following steps: 1. Install Homebrew, using the command /bin/bash-c"$(curl-fsSLhttps://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)". 2. Update Homebrew and use brewupdate. 3. Install MySQL and use brewinstallmysql. 4. Start MySQL service and use brewservicesstartmysql. After installation, you can use mysql-u
How to use MySQL functions for data processing and calculation
Apr 29, 2025 pm 04:21 PM
MySQL functions can be used for data processing and calculation. 1. Basic usage includes string processing, date calculation and mathematical operations. 2. Advanced usage involves combining multiple functions to implement complex operations. 3. Performance optimization requires avoiding the use of functions in the WHERE clause and using GROUPBY and temporary tables.
How to uninstall MySQL and clean residual files
Apr 29, 2025 pm 04:03 PM
To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.
An efficient way to batch insert data in MySQL
Apr 29, 2025 pm 04:18 PM
Efficient methods for batch inserting data in MySQL include: 1. Using INSERTINTO...VALUES syntax, 2. Using LOADDATAINFILE command, 3. Using transaction processing, 4. Adjust batch size, 5. Disable indexing, 6. Using INSERTIGNORE or INSERT...ONDUPLICATEKEYUPDATE, these methods can significantly improve database operation efficiency.
What are the advantages of using MySQL over other relational databases?
May 01, 2025 am 12:18 AM
The reasons why MySQL is widely used in various projects include: 1. High performance and scalability, supporting multiple storage engines; 2. Easy to use and maintain, simple configuration and rich tools; 3. Rich ecosystem, attracting a large number of community and third-party tool support; 4. Cross-platform support, suitable for multiple operating systems.
How to analyze the execution plan of MySQL query
Apr 29, 2025 pm 04:12 PM
Use the EXPLAIN command to analyze the execution plan of MySQL queries. 1. The EXPLAIN command displays the execution plan of the query to help find performance bottlenecks. 2. The execution plan includes fields such as id, select_type, table, type, possible_keys, key, key_len, ref, rows and Extra. 3. According to the execution plan, you can optimize queries by adding indexes, avoiding full table scans, optimizing JOIN operations, and using overlay indexes.
