MySQL and PHP for windows

From Edgar BV Wiki
Jump to: navigation, search

copy all the dlls to \winnt\system32
make sure every one of them has r / rx permissions for the IUSR_computername
make sure the c:\php dir also has these permissions

test php by executing php -h   ----------> not sure if right switch - you should see phpinfo() rolling across the screen

when upgrading look for these directives in c:\winnt\php.ini

; cgi.force_redirect is necessary to provide security running PHP as a CGI under
; most web servers.  Left undefined, PHP turns this on by default.  You can
; turn it off here AT YOUR OWN RISK
; **You CAN safely turn this off for IIS, in fact, you MUST.**
 cgi.force_redirect = 0

; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape 
; (iPlanet) web servers, you MAY need to set an environment variable name that PHP
; will look for to know it is OK to continue execution.  Setting this variable MAY
; cause security issues, KNOW WHAT YOU ARE DOING FIRST.
; cgi.redirect_status_env = ;

; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate
; security tokens of the calling client.  This allows IIS to define the
; security context that the request runs under.  mod_fastcgi under Apache
; does not currently support this feature (03/17/2002)
; Set to 1 if running under IIS.  Default is zero.
 fastcgi.impersonate = 1;

; cgi.rfc2616_headers configuration option tells PHP what type of headers to
; use when sending HTTP response code. If it's set 0 PHP sends Status: header that
; is supported by Apache. When this option is set to 1 PHP will send
; RFC2616 compliant header.
; Set to 1 if running under IIS.  Default is zero.
cgi.rfc2616_headers = 1 

To enable a module, uncomment it in the php.ini. For mime-magic this needs to be added:
[Mime Magic]
mime_magic.magicfile = c:\php\magic.mime

must be added to the c:\winnt\php.ini for mime-magic to work...

As the default is c:\php4\ instead of c:\php (where I've installed it)


net stop mysql or net stop mysqld or mysqdamin -u root shutdown
will stop the service

Stop the service manager and kill it
c:\mysql\bin\mysqld --remove
removes msyqld as a service
mysqld --install
installs it as a service
then you can use the mysqlwinadmin.exe to administer starting and stopping the thing manually.

To upgrade to beyond ver 4