[Resolved] mysql support on php5...can't work

fredouille

Hi all

testing php5 on apache 2 (windows)

impossible to load php_mysql.dll...

any idea ?

bye

bubblenut

did you copy the correct .dll file accross? There's one called php_mysql.dll and one called php_mysqli.dll, you need the first one. This caught me out at first 🙂

fredouille

Originally posted by bubblenut
did you copy the correct .dll file accross? There's one called php_mysql.dll and one called php_mysqli.dll, you need the first one. This caught me out at first 🙂

yes they are in /ext dir of php5

Shrike

They should be in %WINDIR% or %WINDIR%/system32, I think.

fredouille

Originally posted by Shrike
They should be in %WINDIR% or %WINDIR%/system32, I think.

nope..juste the php5ts.dll..

bubblenut

No, you need to copy the dlls there as well, or to the directory where the php executable is (the directory in which you installed php5) although I think the second option only works if you're running php5 as a cgi, not sure though, you'll have to test.

Some extra DLLs are required for some PHP extensions. Please copy the
bundled dlls from the 'dlls/' directory in distribution package to your
windows/system (Win9.x) or winnt/system32 (WinNT, Win2000, XP) directory.
If you already have these DLLs installed on your system,
overwrite them only if something is not working correctly.
Before overwriting them, it is a good idea to backup them or move them to
another folder - just in case something goes wrong.

fredouille

Originally posted by bubblenut
No, you need to copy the dlls there as well, or to the directory where the php executable is (the directory in which you installed php5) although I think the second option only works if you're running php5 as a cgi, not sure though, you'll have to test.

Please copy the
bundled dlls from the 'dlls/'

-> there is no dlls/ dir !!! this is the pb.. and without myql lib it works..I can load curl lib, gd...

bye

bubblenut

Just try copying them into your windows system folder. What's the worst that could happen (don't let the Dr Pepper advert's affect your better judgement here 😉)

linekin

Don't forget libmysql.dll,
copy it to %WINDIR%/system32(WinXP).

devinemke

no need to copy any files to C:\Windows. all i had to do was put the following in my php.ini:

extension_dir = "C:\PHP\ext\"

and then uncomment this line:

extension=php_mysql.dll

pfchin

Hi all,

I did watever should be done, but when i restart my apache2 it prompt an warning box said "PHP startup: Unable to load dynamic library 'D:\php5\ext\php_mysql.dll' - The specified module could not be found". Does anyone know wat is the problem???

Thanks & Regards

bubblenut

Have you checked in the folder D:\php5\ext to see if the file php_mysql.dll is there?

pfchin

yeah, i m very sure it is all there, if i copy the libmysql.dll into %system% it will prompt a warning says cannot initialize API bla bla bla...

Thanks & Regards

nuying117

i meet the same problem,but i have sloved that;

first , my php is installed in the directory : D:\php5\

open the php.ini and set extensions_dir = D:/php5/ext

then ,in the directory D:\php5\ ,there is a dll file called libmysql.dll,copy that file to your system directory,my OS is win2000 and i copy that file to c:\winnt\system32

restart ur apache ,it works~

pfchin

Hi nuying117 thanks for ur reply, i solved the problem already... thanks alots

planetsim

if the problems sovled why not tell what you did as well as marking the thread resolved 😉

philipolson

Do not copy any PHP DLLs to any Windows directory...Ever! That method of installation (for all Windows programs, not just PHP) has been deprecated for a very long time. (to be fair, the PHP manual promoted this practice up until a week or so ago...)

The most common reason Windows+MySQL+PHP5 users have problems is that libmysql.dll (the MySQL client libraries) must be available to the Windows systems PATH so programs, such as PHP, can find it. A proper PHP install has the PHP directory in the systems PATH and that would solve the problem. The reason people often resort to copying massive amounts of files (DLL or otherwise) to the Windows system directory is because the Windows system directory is in the PATH.

In summary, the PHP manual has been updated with all the appropriate information: