| Author |
|
Smitty
Joined: 03 Jan 2008
Posts: 197
|
 Posted: Wed 30 Jan '08 3:15 Post subject: MySQL PHP Connectors |
 |
|
I've been on the hunt for updated MySQL PHP Connectors for a while and I can't seem to find any Windows folks that keep them updated. Can anybody here help?
MySQL used to update them, since the versions bundled with PHP are usually older.
http://dev.mysql.com/downloads/connector/php/
PHP 5.2.5 currently has DLLs built from MySQL 5.0.45, and I'm looking for DLLs for the recently released 5.0.51a.
Thanks for the help, I appreciate it! |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7306
Location: Germany, Next to Hamburg
|
| Posted: Mon 07 Apr '08 21:39 Post subject: |
|
|
Copy libmysql.dll and libmysql.lib from mysql\lib\opt to php and apache\bin folder. That worked for me. And use php_mysql.dll from the php.net download.
I don't think it is the cleverest way to have the file in php and php\bin but other wise it does not work correctly for me. But later when you update again you have to think on replace the files on both locations... sometimes a bit tricky. |
|
| Back to top |
|
Thog
Joined: 12 Feb 2007
Posts: 75
Location: Montreal
|
| Posted: Tue 08 Apr '08 19:09 Post subject: |
|
|
If your httpd.conf file on the bottom put...
LoadFile "C:/Server/PHP526/php5ts.dll"
LoadFile "C:/Server/MySQL/lib/opt/libmysql.dll"
LoadFile "C:/Server/PHP526/libmcrypt.dll"
LoadFile "C:/Server/PHP526/libmhash.dll"
LoadFile "C:/Server/PHP526/libeay32.dll"
LoadFile "C:/Server/PHP526/ssleay32.dll"
This way you never have to copy the files to other places. I hate having to copy files to the windows directory it's the stupidest thing ever. With this technique you never have to.
Depending on the libs you load, you might have to include some other files in here...
As you can see it's now loading the libmysql from the MySQL directory... |
|
| Back to top |
|
Mitron
Joined: 04 Jan 2006
Posts: 63
|
| Posted: Wed 09 Apr '08 20:09 Post subject: |
|
|
| James Blond wrote: | Copy libmysql.dll and libmysql.lib from mysql\lib\opt to php and apache\bin folder. That worked for me. And use php_mysql.dll from the php.net download.
|
Hmm, did you check your phpinfo() after copying the files? The reason I asked is because I ran into a similar issue where php 5.2.5 php_mysqli.dll still shows the 5.0.45 version, even after copying the files over.
I actually had to compile PHP against MySQL 5.0.51a in order for phpinfo() to show the correct version under MySQLi heading. You can check this post for details: http://www.apachelounge.com/viewtopic.php?t=2224 |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7306
Location: Germany, Next to Hamburg
|
|
| Back to top |
|
Mitron
Joined: 04 Jan 2006
Posts: 63
|
| Posted: Fri 11 Apr '08 8:31 Post subject: |
|
|
Yeah, that still didn't work for me. Under the MySQLi heading of phpinfo() the Client API library version is correct but the Client API header version still shows 5.0.45 whether I use MySQL 5.0.51a, 5.0.56 or 5.0.58. I even tried the latest snapshot of PHP hoping they updated php_mysqli.dll.
Rebuilding PHP with the latest MySQL source files and copying the new php_mysqli.dll does fix the issue on my end however. |
|
| Back to top |
|
