Most annoying problem with dreamweaver and SQL database

[herronial]

Come across the most annoying problem ever when trying to import SQL databases into dreamweaver.

First installed apache 2, then PHP 4.4.0, then mysql 4.1.

Got everything up and running, and tried accessing my database through dreamweaver mx2004, which i could as long as i didn't use a password. Came up with the error:

"1251 client does not support authentication protocol requested by server; consider upgrading MySQL client"

Thought this odd considering i had only just downloaded it, searched the web for answer and found it was quite a common problem, and someone suggested updating my PHP software. So I upgraded to PHP 5.0.4 (i think succesfully, the test.php says im running version 5.0.4 so i guess it worked)

Now when i try and import a database in dreamweaver it says "an unidentified error has occured".

I'm using EMS MySQL manager 3 to manage my SQL databases and they are definatly working and can access them fine.

What is dreamweaver on about? Seen lots of people with the same problem but no solutions that i can find. Please someone help. Thanks

BTW: I'm trying to access it on a localhost, thanks

[Iturea]

Try changing the password in MySQLAdmin and then using the new password.

[herronial]

finally figured it out, i needed to put some file in the system32 directory