Unable to connect with local MySql thru Dreamweaver 8

[Guest]

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.

[Newsgroup_User · Accepted solution]

kevibarry wrote:
> In the phpinfo() page it says that my php.ini location is c:\windows which is
> incorrrect it is located in c:\php.

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)
http://foundationphp.com/