Install Mysql Module Php Windows Binary

Posted on by
  1. Php
  2. Php Mysql Extension Install

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP? This tutorial explains how to install Apache, how to install MySQL, how to change the root MySQL password, how to install PHP, and how to see what libraries are available. On Windows, the PHP binary distribution comes with the extensions as separate.dll files that have to be activated in php.ini to be loaded. If this is your case, edit the php.ini file. Find the section that loads the 'extensions' and you will see somewhere something like 'extension = php_mysql.dll' with a semi-colon in front of it. PHP For Windows. This site is dedicated to supporting PHP on Microsoft Windows. If you are using PHP as module with Apache builds from apache.org (not recommended) you need to use the older VC6 versions of PHP compiled with the legacy Visual Studio 6 compiler. It should get you up and running with a Apache/PHP/MySQL install in no time. You could even compare the WampServer config files with your own to see where you originally went wrong. Share improve this answer. Installed as CGI binary. Problems setting up PHP as an Apache module under Windows? To install php+apache+win32+mysql with PHP as an Apache module consider the. Manually install and check Apache, PHP, MySQL on Windows by Remy Pereira on 14th January 2016 If you want to do web development on your local PC or laptop you may use a development environment like WAMP (Windows equivelent of Linux LAMP) or XAMPP.

Php

Active10 years, 11 months ago

I've updated php.ini and moved php_mysql.dll as explained in steps 6 and 8 here.

I get this error…

MySQL doesn't show up in my phpinfo; report.

I've updated the c:Windowsphp.ini file from

to

Result: no change.

I changed the php.ini value of extension_dir thusly:

Result: much more in the phpinfo; report, but MySQL still isn't working.

I copied the file libmysql.dll from folder C:php to folders C:WindowsSystem32 and C:Windows

Result: no change.

I stopped and restarted IIS.

Result: new, different errors instead!

I found several .php files in the website where I had to set variables:

Result: The site works!

Community
Zack PetersonZack Peterson
31.9k76 gold badges196 silver badges278 bronze badges

4 Answers

As the others say these two values in php.ini are crucial.

I have the following in my php.ini: note the trailing slash - not sure if it is needed - but it does work.

Php Mysql Extension Install

Also it is worth ensuring that you only have one copy of php.ini on your machine - I've had problems with this where I've been editting a php.ini file which php isn't using and getting very frustrated until I realised.

Also if php is running as a module within apache you will need to restart the apache server to pickup the changes. Wise to do this in anycase if you're not sure.

a 'php -m' from the cmd prompt will show you the modules that are loaded from the ini file.

Richard HarrisonRichard Harrison
17.9k3 gold badges34 silver badges63 bronze badges

In the php.ini file, check if the extention path configuration is valid.

vIceBergvIceBerg
2,6045 gold badges34 silver badges51 bronze badges

You will need to enable the extension=php_mysql.dll option in the php.ini as well. Epson lq 590 esc p2 windows 7 driver. Also, make sure that the file is in the extension_dir you set.

Oki Microline 1190 Plus 81.1000 For Windows 10 3/18/2016 2/18/2017 oki_microline_1190_plus-81.1000.exe 81kb Sony VGN-SZ7RMN_B, Intel Test Product, Acer Veriton M-480G, HP FL389AA-ABZ a6675it, HP P6520ch-m, Dell Latitude 131L, LG R405-A, Compaq P8657J-ABA SR1000Z NA441, HP G5350nl, Intel LM1WN, Lenovo Lenovo H320 10046, TYAN S2895,, and more. Oki Microline 1190 Plus 80049 For Windows 10 64 bit 7/1/2015 3/22/2017 oki_microline_1190_plus-80049.exe 204kb NEC PC-MY30VBZED, WIPRO WSG59355W7S-0014, Lenovo ThinkServer TS430, HP HP 14 Notebook PC, HP Pavilion dv2000, AnabelleB Pedra BA10, Lenovo 3000 J110 Desktop,, and more. Oki microline 1190 plus driver. Oki Microline 1190 Plus 802.143 For Windows 7 32 bit 9/25/2014 2/11/2017 oki_microline_1190_plus-802.143.exe 210kb HP GL333AA-ABZ m8160.it, Seneca Pro318568, Compaq PX697AA-ABZ SR1419IT IT520, Toshiba Dynabook EX/33JK, HP S5-1028hk, HP KJ401AA-aba A6437C, Fujitsu FMVXN6EG2Z, Panasonic CF47, HP P6635c, Seneca Pro46956, Sony VGN-FJ90S, Fujitsu LIFEBOOK U574, HP GS275AA-ABU IQ772.uk, NEC PC-MK33LLZZUFJF,, and more. Oki Microline 1190 Plus 83032.1 For Windows 8 9/1/2015 3/2/2017 oki_microline_1190_plus-83032.1.exe 173kb Seneca Pro46956, HP NC699AA-ABJ a6740jp, Toshiba Dynabook TX/66HPK, Packard Bell IMEDIA X9678 AIO, Toshiba SATELLITE C850-1P6, SAMSUN Q308, NEC PC-GV267VZDL, IBM D945PLRN, MSI ThirdWave Corporation Prime Series, HP Compaq nx9030,, and more.

You can read more about it at:

Harrison FiskHarrison Fisk
6,3803 gold badges20 silver badges14 bronze badges

On a completely different note, might I suggest WampServer? It should get you up and running with a Apache/PHP/MySQL install in no time.

You could even compare the WampServer config files with your own to see where you originally went wrong.

leekleek
7,3557 gold badges38 silver badges59 bronze badges

Not the answer you're looking for? Browse other questions tagged phpmysqlwindows or ask your own question.

Manual PHP Installation on Windows

Choose Web Server

  • IIS is builtin to Windows. On Windows Server, use Server Manager to add the IIS role. Be sure to include the CGI Role Feature. On Windows Desktop, use Control Panel's Add/Remove Programs to add IIS. See: » https://msdn.microsoft.com/en-us/library/ms181052%28v=vs.80%29.aspx?f=255&MSPPError=-2147217396 For desktop web apps and web-development, you can also use IIS/Express or PHP Desktop

    Example #1 Command line to configure IIS and PHP

    How to manually configure IIS
  • There are several builds of Apache2 for Windows. We support ApacheLounge, but other options include XAMPP, WampServer and BitNami, which provide automatic installer tools. You may use mod_php or mod_fastcgi to load PHP on Apache. If you use mod_php, you MUST use a TS build of Apache built with same version of Visual C and same CPU (x86 or x64). How to manually configure Apache2

Choose Build

Download PHP production releases from » http://windows.php.net/download/. A lot of testing and optimization is already done on the snapshot and qa releases, but you are welcome to help us do more. There are 4 types of PHP builds:

  • Thread-Safe(TS) - use for single process web servers, like Apache with mod_php

  • Non-Thread-Safe(NTS) - use for IIS and other FastCGI web servers (Apache with mod_fastcgi) and recommended for command-line scripts

  • x86 - production use of PHP 5.5 or 5.6 or 7.0.

  • x64 - production use of PHP 7.0+ unless its a 32-bit only version of Windows. 5.5 and 5.6 x64 are experimental.

There are no user contributed notes for this page.
  • Installation on Windows systems