Unable to connect with local MySql thru Dreamweaver 8

Unable to connect with local MySql thru Dreamweaver 8

Post by kevibarr » Thu, 17 Aug 2006 02:59:59

My issues began as the title suggests with connnecting to MySql and getting the
error that MySql modules were not loaded etc. I know MySql is ok which I
verified thru Navicat & MySql Administrator, can create tables, add records etc.

Then I looked at the PHP config, apache works and can view phpinfo() page. But
when I make changes to the loaded extensions nothing changes in the phpinfo
output. My overall config is:

Windows XP
PHP 5.1.4
MySql 5.0.19
Apache 2.0.50

In the phpinfo() page it says that my php.ini location is c:\windows which is
incorrrect it is located in c:\php. There is no other php.ini file on my
machine. If I move the php.ini into c:\windows I don't get my phpinfo() page,
no error either just a done message in the bottom left corner of Firefox.

I downloaded and am using the latest MySql connectors php_mysql.dll &
libmysql.dll. I've worked on this for the past two days and have considered
installing WAMP but don't want to hose my install of MySql & Apache.

Unable to connect with local MySql thru Dreamweaver 8

Post by David Powe » Thu, 17 Aug 2006 07:07:00

You're using Navicat, which seems to have some evil influence over PHP
installations. I have never installed it myself, but I know that it
installs libmysql.dll in C:\WINDOWS\system32. Often the version
installed by Navicat is out of date. Since Navicat goes berserk if you
remove libmysql.dll from that location, you will need to copy the
updated version to your system32 folder.

Also make sure that your PHP folder is in the Windows PATH.

David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)