MySQL and PHP for windows

From Edgar BV Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
PHP
---

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)


Mysql
-----

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