Page 3 - PHP 5 php_mysql.dll problem width mysql 4.x & 5.0 libmysql.dll

Hi,

I've the same problem. I'm using PHP5 and MySQL 5.0 under Windows. I've downloaded php 5.0.4 package. Than I've copied libmysql.dll to CHP, CHPEXT, C:WINDOWS, C:SYSTEM32 and I've added CHP, CHPEXT and CROGRAM FILESMYSQLMYSQL5.0BIN to system path. After restarting computer I've run cmd.exe, typed php -m. And of course I still have the same error "Unable to load dynamic labrary './ext/php_mysql.dll' ".

Now I'm shure, that the problem isn't in configuration of Apache Server ( that's why I use command "php -m" ). But I have no idea how to make it works.

Do you have any idea?

Adam

Adam,

To make my installation work, I had to first download the windows zip file. Then I unzipped php_mysql.dll and copied it to system32. That solved the problem. I had already copied libmysql.dll to the other directories that you mentioned but that had not solved the problem for me.

you the man!

Hi! Thanks to all who posted anonymously especially the guy who told me to put libmysql.dll into apachebin that solved it.. but to help others with their frustration, Here's all the details, apologies if its a bit long, just trying to help .

Windows XP home edition (poor student)
Apache 2.0.55
PHP 5.0.4
mysql-essential 4.1.13a

Apache was working and would load php scripts and html and all was good before i tried to access MySQL...

My original problem was simply that i couldn't connect to mysql:

just would not work and initially i just had a BLANK PAGE. In another thread I read the error settings in the reccomended php.ini file were optimised for working websites and errors would be logged rather than displayed. so i renamed the dist-php.ini file, uncommented the extension=php_mysql.dll line in my new php.ini file and quoted the full extension path
extension_dir="c:phpext"

...Yay i now had error messages: (never thought i'd say that!)

fatal error: calll to undefined function

and when i restarted apache i also had an error:

PHP Startup: Unable to load dynamic library 'c:phpextphp_mysql.dll'-The specified procedure could not be found.

Whats more i would get this message twice (?) and also the same message for the php_mysqli extension (i didn't need it i was just testing) however i then tried the extension PHP_bz2.dll for a laugh and it didn't incur an error when apache restarted as it didnlt need any other libraries (the others still did though).

I already had the system PATH including c:php as reccomended but no luck. i put libmysql.dll in all php folders and my windows folder but still no luck. then i read the afore mentioned post to purt it in my Apache2bin folder and it was solved, no error messages. bingo. My only problem now is that apache wont let me access index.php unless i type in http://localhost/index.php, if i put an index.html in by root folder its fine but that's probably caused by faffing with the httpd.conf file at some point in my struggles.

Hope tis was a use thanks again to the apache2bin person!
good luck

Probably I'm the last person to have gotten this problem solved, but I still thought I'd post my solution, since most of the others I've read didn't help me.

My problem was that when Apache loaded, I got that "Unable to load php_mysql.dll... not found..." crap, twice. After having set the path variable so that my libmysql.dll was found, I only got the error message once. (Moving it to windowssystem had the same effect.) All my settings in the php.ini seemed find and extension_dir pointed exaktly to the spot where php_mysql.dll was located.

Then I read somewhere that the problem could occur if you didn't restart your computer at the right stage of the installation of mySQL and PHP. So the solution to my problem was to comment the line "extension=php_mysql.dll" out with a ; , then restart my computer, remove the ; from the same line, restart again, and then there were no error messages. (I haven't tested actually using the installation, though.) So, if nothing else works for you, then this could be worth trying.

Good luck

Peter

As with iAN, the "Old" libmysql, weighing at 290 KB, was my problem, where the "new" version is 1.01MB.

My situation differed, as the "old" libmysql was stored in c:windowssystem32 on Windows 2003. Overwriting it w/ the new library and rebooting did the trick.

Perhaps some of the folks who are still banging their heads against the wall could run a system-wide search for libmysql and overwrite whichever one is undersized.

[Frosty]

> "Perhaps some of the folks who are still banging their heads against the wall could run a system-wide search for libmysql and overwrite whichever one is undersized."

Thank you very much !! I found that I had an old version of libmysql.dll into my apache directory.
I replaced this file with the new version and now it works fine :-)))

hmn i u ppl better check the php-5.0.5-Win32.zip, its got something that ppl looking for -.- and i just knew about it and im confuse which one should i install ,or should i manually unzip and set the thing manualy -.- but after i happen to deal with all the problem i still confront with other problems --> what does this mean--> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:...mysql.php on line 7
Could not connect im really confuse now -.-

just incase people still having prob
mysql_create_db()
not supported in newer version
use
mysql_query('CREATE DATABASE...

Copy php_mysql.dll solves the problem for me with apache 2.0.55 server, php 5.0.5 and mysql 4.0.13 server.

Copy php_mysql.dll to windows/system32 directory solves the problem for me with apache 2.0.55, php 5.0.5 and mysql 4.1.15.

After installing the windows binary (5.05) and copying php_mysql.dll to the windowssystem32
directory, I still got an error message stating the php_mysql.dll could not be found.

To solve this problem I had to copy the php5ts.lib as well to the windowssystems32 directory.

I hope this will solve the php_mysql.dll problem for you.

Success,

Marcel Lubbers

After installing the windows binary (5.05) and copying php_mysql.dll to the windowssystem32
directory, I still got an error message stating the php_mysql.dll could not be found.

To solve this problem I had to copy the php5ts.lib as well to the windowssystems32 directory.

I hope this will solve the php_mysql.dll problem for you.

Success,

Marcel Lubbers

After reading multiple post where members were copying DLLs in every place possible, I spent a hour and experimented with what a minimal configuration that would work under Windows XP would entail.

1. First and formost php.ini must be in the Windows root directory - in my case c:Windows

2. Configure php.ini
a)The remove the ";" from extension=php_mysql.dll or extension=php_mysqli.dll depending on which interface you will be using.
b)Configure the directory in which the loadable extensions (modules) reside - in my case this was extension_dir = "CHP5ext"

3. Modify your windows enviroment variable PATH (can be the user or system wide)to point to the insatlled PHP5 directory - in my case this was cHP5.
* Both libmysql.dll & libmysql1.dll are installed here by default.

//You're now good to go :-)

-- Advantage to this solution is that you don't have DLLs spread all over your system that can and will bite you the next time you upgrade.

Copying the libmysql.dll into the windows directory worked for me as well - thanks!