unable to load dynamic library C:\php\ext\php_mysql.dll - procedure

If you get the above error when trying to install/run PHP5 using Apache
and Windows XP, I just thought i would let you know my experience.  It
took me many hours to figure this out, but it was not a problem with the
php_mysql.dll file at all.

It turns out I had an incompatible libmysql.dll file in my
C:\windows\system32 folder.  So, to make it work, i had to copy the
libmysql.dll file given in the PHP distribution into C:\windows\system32.

Well, just wanted to let you know my experience, hopefully this can help
some one.

-d

Andy Hassall wrote:

>
>  Better would be to remove the DLL from the Windows system directory, and
> instead set PATH to include the path to the DLL.
>
>  Dumping DLLs into the Windows system directory tends to lead to this sort
 of
> problem - better to keep the DLLs in user directories rather than dumping 
them
> into the operating system directories.
>


I changed my path.  Unfortunately, it kept picking up the libmysql.dll
from C:\mysql\bin, even though C:\php is first in my path.

-d

yes i had the same problem and the same solution solved it. thank you. apach
e 2.0/php 5/mysql 4.0.21-nt/windows xp sp2

-alex

Whatismore mySQL won't run if you don't copy this file 'libmysql.dll' bundle
d with PHP5 into your system32 directory. I understood this because I had *n
o* 'libmysql.dll' on this path.
--
Fabrice G. Boyer

Did all that and now I have another error which is: "Cannot load mysql exten
sion" when I go to phpMyAdmin.



quote:
Originally posted by Fabruccio 
Whatismore mySQL won't run if you don't copy this file 'libmysql.dll' bundle
d with PHP5 into your system32 directory. I understood this because I had *n
o* 'libmysql.dll' on this path.
--
Fabrice G. Boyer 

Ok - got it!!

Actually mysql and PHP were running fine after I changed the extension_dir t
o the correct directory.

The Problem after that was w/ phpMyAdmin and it's configuration.

Here's what I did to fix that:

code:


'host' from localhost to the machine host name 'extension' to 'mysqli' 'user
' to a user who has access to MySQL, i.e. can log onto MySQL on the server '
password' to the password of the user

Post Follow-up to this message