I am starting development with PHP/MySql with Dreamweaver,
and trying to set up MySql/PHP on my machine. I am currently running
Windows 2000 professional and IIS is installed. I have gone through
the routine of setting up my remote server, local folder and testing
server successfully.

The MySql version i have istalled is "mysql-4.0.14a-win".
I can create databases, tables and perform all SQL commands on the sql monitor.

The PHP engine I installed is "php-4.3.0-installer". I created php pages correctly.

My problem comes with creating my SQLConnection under the Applications/ databases tab.
Under the MySql connection dialog box, I enter the connection name i want, localhost
for MySQL Server, my Username and password that I created when I set up MySql,
I can select my database but when I click on Test I get the error message
1045 - Access denied for corey@localhost(Using password:Yes).
If I click on OK it actually does create the connection under the application window.
I can click on the connection but when I try to view the tables in the database it says none.

I have a feeling there are permissions involved here but I do not know where to set them.
When I click on MysqlAdmin my user and password info is correct when I click the myIni tab.

Corey,
Try this, try logging in without a password. If that works, then that means that the two accounts @localhost and @whatever.your.domain.com don't have passwords enabled. My suggestion is to delete them both, and then login using the account you created. That should help

try these links maybe its can be useful information for u...

www.macromedia.com/support/dreamweaver/database.html