troubleshooting Question

Error Message: "An unidentified error has occurred."  When trying to connect Dreamweaver to MySQL database with php.

Avatar of norminater
norminater asked on
Adobe Dreamweaver
6 Comments1 Solution4006 ViewsLast Modified:
Here is my setup:

Windows XP Pro with IIS
PHP 5.0.3
MySQL 4.1.7
Dreamweaver MX 2004

I have tested PHP with phpinfo(); and no problems.  I have also tested PHPs access to MySQL and have no problem connecting.  I have MySQL Administrator and MySQL Control Center installed and have no problems accessing the database through either program. I ran CREATE queries through MySQL Control Center to create my tables.  For purposes of getting the connection working I am using a simple user account called www with password www.  The MySQL database name is also www.  the www acount has SELECT, INSERT, UPDATE, DELETE and CREATE priveleges to the www database, but no access at all to the mysql database.  Based on an article I read,  I ran these 2 queries to change the password for the www acount to the old_password format:

UPDATE mysql.user SET Password = OLD_PASSWORD('www') WHERE User = 'www'
FLUSH PRIVILEGES

After running these queries I enabled old passwords in the mysql.ini file and restarted mysql.  I also went through all of the suggestions at the macromedia page that is dedicated to troubleshooting this problem:

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16515

I started out using apache2, but I switched to IIS because I thought it might be more compatible with Dreamweaver.

I am an experienced IT professional who is farely new to PHP, I would like to get my blog working and then maybe use PHP and MySQL to generate reports for my company. I am using a trial version of Dreamweaver and I will make my decision to purchase it based on whether or not I can get it to work with MySQL.
ASKER CERTIFIED SOLUTION
modulo

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros