For Programmers: Free Programming Magazines  


Home > Archive > PHP Language > September 2006 > unable to load dynamic library C:\php\ext\php_mysql.dll - procedure









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

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

2004-09-08, 3:55 am



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
Doug

2004-09-10, 8:55 pm



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
arshapro

2004-09-30, 10:40 am

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

-alex
Fabruccio

2004-10-11, 11:45 pm

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

2006-09-05, 3:47 pm

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



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

clem_c_rock

2006-09-06, 3:44 pm

Ok - got it!!

Actually mysql and PHP were running fine after I changed the extension_dir to 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
dark_dragun

2006-09-15, 4:01 pm

quote:
Originally posted by Doug
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



Thank you so so very much lol, I was pulling my hair out on this one until I rewad your post. My current libmysql.dll was only 224k big, and the one I use that fixed the problem is now 1436 k big lol huge difference.
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com