Configure MySQL extension

dhydrated

I'm unable to activate MySQL extension. I have configure the php.ini file but when i tried to run the apache server, it says that php_mysql.dll file can't be found. In the php.ini file, i've set the extension_dir to the folder that contains the php_mysql.dll file and also uncommented the extension=php_mysql.dll line. What else do I need to do to activate the MySQL extension?

tsinka

Hi,

copy the libmysql.dll file that comes with the zip PHP package to system32.

Thomas

dhydrated

I've copied the libmysql.dll and php_mysql.dll files to the System32 folder but still i get this message:

"Unable to load dynamic library '.;c:\php\ext\php_mysql.dll' - the specific module can't be found" when i tried to run the apache server.

I've set the extension_dir to ".;c:\php\ext" and uncommented the extension=php_mysql.dll line. What else should I check?

tsinka

I think the error message gives you a hint what might be wrong.

Remove .; from extension_dir so that it is just:

c:\php\ext

At least I hope that this is the problem 🙂

Thomas

dhydrated

thank you tsinka.. you really made my day a lot better.. it works finally...

but I'm curious, why do i have to delete the '.;' on the extension_dir but on the include_path its uses '.;' such as include_path=".;c:\php\pear".

tsinka

The extension dir specifies exactly the directory (just that directory) where the extensions are.

The include_path is a list of directories that PHP searches for PHP scripts you want to include (like . for the current dir or e.g. c:\php\pear which contains the PEAR library). You can add more directories like a global include directory outside DOCUMENT_ROOT. It is recommended to put e.g. configuration data in scripts outside DOCUMENT_ROOT so they can't be read accidently (generally: any data/scripts that do not have something to do with output directly).

If you use just

include "somescript.php";

then PHP will search all those directories for a script named somescript.php

Thomas