Unable to load dynamic library php_mysql.dll

trib4lmaniac · 10-30-2004, 10:32 AM

Unable to load dynamic library 'c:\web\php\ext\php_mysql.dll' is the error. The file blatently is there! How do I get MySQL working

Googled it and most answers say in php.ini set extension-dir correctly (which it is) and copy libmysql.dll and php_mysql.dll to various locations (which I have tried) am I missing the perfect combo? Tried putting them both everywhere at the same time (\windows, \windows\system[32], \web\php, \web\php\ext).

<edit>Should add that this is MySQL 4.1 (latest), PHP 5.0.2 and Apache 2.51</edit>

trib4lmaniac · 10-30-2004, 01:40 PM

Ok, sorted @ last. Turned out I needed to use an older version of libmysql.dll (the one that bundles with php) and not the one that came with mysql.

For those who need to know... php_mysql.dll -> c:\WINDOWS, libmysql.dll -> c:\WINDOWS\system32, libmysql should be the one that came in the php zip/installer.

eveready1010 · 02-15-2005, 12:42 PM

I was having the same problem. Your solution did the trick!

SKJoy2001 · 03-23-2005, 10:25 AM

Your trick applies to the MySQL specific extension only, what about the other extensions like PHP_MBSTRING, PHP_GD, PHP_IMAP? Please help me if you have the resolution.

Tythora · 01-29-2009, 04:21 PM

OMG, thank you SOOOO MUCH!!!!!!
I spent the last 5 hours trying out different versions, packages etc... Thank you, thank you, thank you!!!!

I just replaced mysqlib.dll in windows/system32 with the one in PHP and it worked!
Thank you again!

conrad_escape · 03-20-2009, 01:34 AM

The elegant solution is to add "c:\php" (or your php path) to the System variable "Path" (Control Panel / System / Advanced tab / Environment Variables)
so libmysql.dll or libmhash.dll or whatever are beeing loaded directly from php's dir if needed.

10-30-2004, 10:32 AM	PM User \| #1
trib4lmaniac Regular Coder Join Date: Feb 2004 Location: Cornwall, UK Posts: 535 Thanks: 0 Thanked 0 Times in 0 Posts	Unable to load dynamic library php_mysql.dll Unable to load dynamic library 'c:\web\php\ext\php_mysql.dll' is the error. The file blatently is there! How do I get MySQL working Googled it and most answers say in php.ini set extension-dir correctly (which it is) and copy libmysql.dll and php_mysql.dll to various locations (which I have tried) am I missing the perfect combo? Tried putting them both everywhere at the same time (\windows, \windows\system[32], \web\php, \web\php\ext). <edit>Should add that this is MySQL 4.1 (latest), PHP 5.0.2 and Apache 2.51</edit> Last edited by trib4lmaniac; 10-30-2004 at 12:40 PM..

02-15-2005, 12:42 PM	PM User \| #3
eveready1010 New to the CF scene Join Date: Feb 2005 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	php_mysql.dll I was having the same problem. Your solution did the trick!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

10-30-2004, 01:40 PM	PM User \| #2
trib4lmaniac Regular Coder Join Date: Feb 2004 Location: Cornwall, UK Posts: 535 Thanks: 0 Thanked 0 Times in 0 Posts	Ok, sorted @ last. Turned out I needed to use an older version of libmysql.dll (the one that bundles with php) and not the one that came with mysql. For those who need to know... php_mysql.dll -> c:\WINDOWS, libmysql.dll -> c:\WINDOWS\system32, libmysql should be the one that came in the php zip/installer.

03-23-2005, 10:25 AM	PM User \| #4
SKJoy2001 New to the CF scene Join Date: Feb 2005 Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts	Your trick applies to the MySQL specific extension only, what about the other extensions like PHP_MBSTRING, PHP_GD, PHP_IMAP? Please help me if you have the resolution.

01-29-2009, 04:21 PM	PM User \| #5
Tythora New to the CF scene Join Date: Jan 2009 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	OMG, thank you SOOOO MUCH!!!!!! I spent the last 5 hours trying out different versions, packages etc... Thank you, thank you, thank you!!!! I just replaced mysqlib.dll in windows/system32 with the one in PHP and it worked! Thank you again!

03-20-2009, 01:34 AM	PM User \| #6
conrad_escape New to the CF scene Join Date: Mar 2009 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	The elegant solution is to add "c:\php" (or your php path) to the System variable "Path" (Control Panel / System / Advanced tab / Environment Variables) so libmysql.dll or libmhash.dll or whatever are beeing loaded directly from php's dir if needed.