Here is my setup:
Windows XP Pro with IIS
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'
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:
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.
UPDATE mysql.user SET [Password] = OLD_PASSWORD('www') WHERE User = 'www'