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

Rather than copy the libmysql.dll into your windows folder, it is probably better to follow the recommendations on the php website, and just add C:php to your path variable. Then the libmysql.dll that came with PHP 5.0.x is automatically loaded. Make sure your extension_dir is set correctly in your php.ini file. I explicitly set mine as "c:/php/ext/" rather than the suggested "./ext/". I have loaded PHP 5.0.2 on three different OSs this way, xp-pro, xp-home, and server 2003. I did run into the above problem (Unable to load dynamic library 'c:phpextphp_mysql.dll' - The specified procedure could not be found.') once, but I discovered I had a corrupt php_mysql.dll. Once I fixed that, everything was fine...

I have the same problem. unable to load extension

You must install MYSQL 3.23.57 for php5 because Client API version is 3.23.57.

Man ... you fixed my problem after about an hour of frustration. Thank you!!!!

blll... what? But I want to have UTF8 support for my stuff... Whats up? With PHP5 I cannot have it.

(Support for UTF8 in MySql comes with 4.1 version number...) **** "=_)

check that your extension_dir is correct in the php.ini if you are using php 5.0.2 it should look like this on winXP.

extension_dir = "C:phpext"

No, this is incorrect -- it is possible to use PHP 5 and MySQL 4.x together without problems. I downloaded the latest version of Apache 2, the latest version of PHP 5, and the latest version of MySQL 4 today (x86 Windows binaries) and set up Apache 2 / PHP as normal.

The problem that you are having is that you are using the LIBMYSQL.DLL library which comes with MySQL, which will not work. You must use the one which comes with PHP 5 (it is in the root directory, by default C:php). If you have added C:php to your path then you should be fine; if you have trouble regardless or if you have not, then copy C:phplibmysql.dll to the 'bin' subdirectory of your Apache 2 installation (Crogram FilesApache GroupApache2binlibmysql.dll by default).

Everything will then work fine.

I copied the old libmySQL.dll from mySQL 3.x to C:WINDOWSsystem32 and it worked.
Thanks so much for the analysis.

I've gone through all the messages in this post. I've tried all the solutions, still PHP5 on my machine cannot access MySQL. I've put libmysql.dll into all the directories but still it doesnt work. HELP!!! Im desperate

Ok I have had this bugger of a problem more then once. From what I've read on different forums PHP5 does not support mySQL.

Ragnarok
You do know that PHP5 doesn't have MySQL installed like PHP4 right?

http://www.daniweb.com/techtalkforums/thread7226.html

HOW TO FIX!

Follow the installation instruction for PHP and mySQL. Now download php 5 http://php.mirrors.ilisys.com.au/get/php-5.0.4Win32.zip/from/a/mirror

Open the zip, do not extract the all the files to your hard drive... extract only the ext fold into C:/php/

Restart your IIS or Apache. Now you can stop pulling ya hair out and live again.

Wasabi
http://www.john-mclellan.com

Thanks for the tip on copying the file to windows. Thanks a million.

For people using php5 with mysql 4 or higher, this might help. Thanks to valgevali for the original post which pointed me in the right direction:



Following this, I decided to recompile php_mysql.dll with those two commands omitted against the latest mySQL 4 library. This worked beautifully for me. If it helps anyone, here is the file:

ftp://ftp.crystalhome.net/php_mysql.dll

It's all bull****.
I wasted a week and it still does not work.

i removed all files

put php_mysql.dll into all possible folders- windous etc

put libmysql.dll everywehere.

removed all one by one etc etc.

unqutoed extension=php_mysql.dll, showed extension_dir - all possible wayes - quoted, unquoted, slash, bakslahs, no slash at the end,
low case underline
configured httpd,

put c:php5 and c:phpbin into the PATH

did this, did that, , reloaded every time

probably 500 different variations.

still f... program can not load php_mysql.dll.

I do not know what is this.

System: windows 32, windows XP home edition , PHP5 and mysql 4.02 -

All the stuff was supplied on a CD from the book : PHP, MYSQL and APche all in one.

Still all that crap does not work.

Don't know what to do.

Will probably try to remove everythinh and go with lower verstion of PHP4 and mysql, if can find good one.

For those who jsut unquoted and fixed the problem - they were lucky.

Make sure you restart the computer each time you try installing or uninstalling PHP5 or mySQL. Otherwise the same error will show even if you have completed the installation correctly. Which in turn will cause you frustration and make you sound like a bit of a wanker!

Good luck!

I also encountered similar problems - "End point could not be..." + "Unable to load extphp_mysql.dll" when (re)starting Apache2. (Apache2, Win2k, PHP5, MySQL 4.x)

Tried putting CHP into the path: same errors
Tried copying libmysql.dll into c:WINNT and c:WINNTSystem32: same errors

Turns out that there is a copy of libmysql.dll in the Apache2bin directory - replaced that one with the one included in PHP5, and problem solved.

"Old" libmysql weighs in around 290 KB, "new" version is 1.01MB. Appears Apache looks to it's own bin directories for dll's before searching %path%.

iAn