Nginx + PHP + MySQL on Windows in 六 minutes
日期：2014-05-16 浏览次数：20992 次
Nginx + PHP + MySQL on Windows in 6 minutes
come from http://eksith.wordpress.com/2010/11/07/nginx-php-mysql-windows/3/
The last time I posted a tutorial on Nginx, there wasn’t a native port of the server available. Riez Opuz posted a link to his Xenstack project on that post that prompted me to write the rest of what I’ve been putting off. It’s a good way to tweak the stack to your own needs.
I tried to leave this as “in 5 minutes”, but then I remembered how long it would take to download MySQL… Even on broadband.
Kevin Worthington had very kindly provided a Cygwin build that ran on Windows, however Nginx now has a Windows build that we can use and this time, we can add MySQL to the list as well. To keep everything compatible, we’ll be using the 32 bit versions for all downloads.
Once you’ve also downloaded Nginx (0.8.53 at the time of this post), head on to the PHP libraries and remember to download the Windows Libraries only (5.3.3 as of today) and select the thread safe version. The first steps are the same with the exception of the download link to MySQL and we need the no-install download.
Make sure to follow this directory structure!
Extract the Nginx files to C:\nginx
Extract PHP to C:\nginx\php
Extract MySQL to C:\nginx\mysql
First, let’s configure MySQL
MySQL no-install is a freakin’ huge download so feel free to delete mysql-test, Embedded, sql-bench and folders named debug once unzipped. If you want to minimize the folder even more, you can optionally delete any .pdb files. This would come in handy if you want to deploy the whole ensamble on a thumb drive or package it for a demo application and are really penny-pinching the available storage space.
Once the cleanup is complete, copy my-medium.ini in C:\nginx\mysql\ into my.ini. I think the medium configuration takes care of most uses and, for a moderately busy site, it fares pretty well.
Always try to copy exising files before making changes instead of outright renaming them. This way, if something goes wrong with the new configuration, we still have the original handy to start over..
Open up the newly copied my.ini file and change the [client] block to match the following.
[client]
#password = your_password
port = 3306
socket = c:/nginx/mysql/tmp/mysql.sock
Note the Unix style forward-slashes.
Now in the [mysqld] block in the same file, change to match the following :
[mysqld]
port = 3306
socket = c:/nginx/mysql/tmp/mysql.sock
basedir = c:/nginx/mysql
datadir = c:/nginx/mysql/data
bind-address = localhost
enable-named-pipe
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
Now let’s try and run our MySQL server
Start a new command line window…
Note: If you’re running Windows Vista or above with UAC enabled, you need to right click on the command line link and select “Run as administrator”.. If you get a message saying “Install/Remove of the Service Denied!” when trying to start MySQL later on, then you probably have UAC running, so this step is very important.
Navigate to C:\nginx\mysql\bin\ and run :
mysqld --install-manual
There should be a slight delay followed by a “Service successfully installed”. We then must run :
net start mysql
…And if there are no errors noted, then Congratulations!
Before we proceed, we need to run some housekeeping operations. In the same command line window, run :
mysqladmin -u root password newpassword
Where newpassword is your new MySQL root passwor
come from http://eksith.wordpress.com/2010/11/07/nginx-php-mysql-windows/3/
The last time I posted a tutorial on Nginx, there wasn’t a native port of the server available. Riez Opuz posted a link to his Xenstack project on that post that prompted me to write the rest of what I’ve been putting off. It’s a good way to tweak the stack to your own needs.
I tried to leave this as “in 5 minutes”, but then I remembered how long it would take to download MySQL… Even on broadband.
Kevin Worthington had very kindly provided a Cygwin build that ran on Windows, however Nginx now has a Windows build that we can use and this time, we can add MySQL to the list as well. To keep everything compatible, we’ll be using the 32 bit versions for all downloads.
Once you’ve also downloaded Nginx (0.8.53 at the time of this post), head on to the PHP libraries and remember to download the Windows Libraries only (5.3.3 as of today) and select the thread safe version. The first steps are the same with the exception of the download link to MySQL and we need the no-install download.
Make sure to follow this directory structure!
Extract the Nginx files to C:\nginx
Extract PHP to C:\nginx\php
Extract MySQL to C:\nginx\mysql
First, let’s configure MySQL
MySQL no-install is a freakin’ huge download so feel free to delete mysql-test, Embedded, sql-bench and folders named debug once unzipped. If you want to minimize the folder even more, you can optionally delete any .pdb files. This would come in handy if you want to deploy the whole ensamble on a thumb drive or package it for a demo application and are really penny-pinching the available storage space.
Once the cleanup is complete, copy my-medium.ini in C:\nginx\mysql\ into my.ini. I think the medium configuration takes care of most uses and, for a moderately busy site, it fares pretty well.
Always try to copy exising files before making changes instead of outright renaming them. This way, if something goes wrong with the new configuration, we still have the original handy to start over..
Open up the newly copied my.ini file and change the [client] block to match the following.
[client]
#password = your_password
port = 3306
socket = c:/nginx/mysql/tmp/mysql.sock
Note the Unix style forward-slashes.
Now in the [mysqld] block in the same file, change to match the following :
[mysqld]
port = 3306
socket = c:/nginx/mysql/tmp/mysql.sock
basedir = c:/nginx/mysql
datadir = c:/nginx/mysql/data
bind-address = localhost
enable-named-pipe
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
Now let’s try and run our MySQL server
Start a new command line window…
Note: If you’re running Windows Vista or above with UAC enabled, you need to right click on the command line link and select “Run as administrator”.. If you get a message saying “Install/Remove of the Service Denied!” when trying to start MySQL later on, then you probably have UAC running, so this step is very important.
Navigate to C:\nginx\mysql\bin\ and run :
mysqld --install-manual
There should be a slight delay followed by a “Service successfully installed”. We then must run :
net start mysql
…And if there are no errors noted, then Congratulations!
Before we proceed, we need to run some housekeeping operations. In the same command line window, run :
mysqladmin -u root password newpassword
Where newpassword is your new MySQL root passwor
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
