在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
AI Hentai Generator
Generate AI Hentai for free.
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
1375
52
Can I retrieve the database password in Navicat?
Apr 08, 2025 pm 09:51 PM
Navicat itself does not store the database password, and can only retrieve the encrypted password. Solution: 1. Check the password manager; 2. Check Navicat's "Remember Password" function; 3. Reset the database password; 4. Contact the database administrator.
MySQL: The Ease of Data Management for Beginners
Apr 09, 2025 am 12:07 AM
MySQL is suitable for beginners because it is simple to install, powerful and easy to manage data. 1. Simple installation and configuration, suitable for a variety of operating systems. 2. Support basic operations such as creating databases and tables, inserting, querying, updating and deleting data. 3. Provide advanced functions such as JOIN operations and subqueries. 4. Performance can be improved through indexing, query optimization and table partitioning. 5. Support backup, recovery and security measures to ensure data security and consistency.
How to create navicat premium
Apr 09, 2025 am 07:09 AM
Create a database using Navicat Premium: Connect to the database server and enter the connection parameters. Right-click on the server and select Create Database. Enter the name of the new database and the specified character set and collation. Connect to the new database and create the table in the Object Browser. Right-click on the table and select Insert Data to insert the data.
Navicat cannot connect to MySQL/MariaDB/PostgreSQL and other databases
Apr 08, 2025 pm 11:00 PM
Common reasons why Navicat cannot connect to the database and its solutions: 1. Check the server's running status; 2. Check the connection information; 3. Adjust the firewall settings; 4. Configure remote access; 5. Troubleshoot network problems; 6. Check permissions; 7. Ensure version compatibility; 8. Troubleshoot other possibilities.
How to create a new connection to mysql in navicat
Apr 09, 2025 am 07:21 AM
You can create a new MySQL connection in Navicat by following the steps: Open the application and select New Connection (Ctrl N). Select "MySQL" as the connection type. Enter the hostname/IP address, port, username, and password. (Optional) Configure advanced options. Save the connection and enter the connection name.
Navicat connects to database error code and solution
Apr 08, 2025 pm 11:06 PM
Common errors and solutions when connecting to databases: Username or password (Error 1045) Firewall blocks connection (Error 2003) Connection timeout (Error 10060) Unable to use socket connection (Error 1042) SSL connection error (Error 10055) Too many connection attempts result in the host being blocked (Error 1129) Database does not exist (Error 1049) No permission to connect to database (Error 1000)
How to view table notes in navicat
Apr 09, 2025 am 06:00 AM
How to view table notes in Navicat: Connect to the database and navigate to the target table. Switch to the Notes tab. Check whether there is any table notes.
How to connect to local mysql in navicat
Apr 09, 2025 am 07:45 AM
To connect to a local MySQL database using Navicat: Create a connection and set the connection name, host, port, username, and password. Test the connection to make sure the parameters are correct. Save the connection. Select a new connection from the connection list. Double-click the database you want to connect to.
