Dreamweaver Database connection MySQL Error# 2000 - authentication

To work with DataAssist, I am trying to setup DreamweaverCS3 to connect to our removte database. I has worked before.

Using:
Dreamweaver CS3
XAMPP (with MySQL 5.0.10 - for local testing but not setup yet in Dreamweaver)
DataAssist

When connecting we get the error:
MySQL Error#: 2000
nysqulnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administarion tool to reset your password with the command SET PASSWORD = PASWWORD("your existing password.") This will store a new, and more secure, hash value inmysql.user. If this user is used in other scripts executed by PPH 5.2 or earlier you might need to remvoe the old-passwords flah from you my.cnf file

Please recomend how to setup. And/or if we should just connect to the local database unser the xampp directory and will that effect the coding?

What version of XAMPP Do you have installed?

The latest version of XAMPP includes MySQL 5.6.14

http://www.apachefriends.org/download.html

If you continue to have the same problem, it is a MySQL configuration issue, I would post to the Apache Friends forum for help with this problem:
http://community.apachefriends.org/f/

My development computer is running on WinXP Pro. Therefore the most resent version of XAMPP that supports that operating system is:
XAMPP Windows 1.8.2 (DOWNLOADED BUT PROGRAM INSTALLED VS. 1.8.1
Installed:
XAMPP Windows 1.8.1
Apache 2.4.3 (download says 2.4.7 but installed config says 2.4.3)
MySQL 5.5.34 (phpinfo says 5.0.10)
PHP 5.4.7

The newer version of MySQL by default use the newer hashing alogorithm for connections passwords. I belive that this setting can be modified so that I can connect using the older method. That would be perfered if anyone knows how. Configuration has not been easy to setup and rather than reinstalling everything with an older version, it would be perferable to be more current when the site is migrate to a server running the enhansed connection method.

the connection method is determined by the MySQL server, not the code that passes it.

You will get better answers on configuring MySQL at the Apache Friends forum.

What happens if I have Dreamweaver simply connect to it? Will DataAssist and the other Webassist programs change the code in the pages and interfer with their operation once they are uploaded to the webserver?

i dont understand the question. the WebAssist extensions don't change the connection. they just use the connection code that Dreamweaver creates.

The question as to the affect of code written/used by Webassist plug-ins while creating the webpages in Dreamweaver...DataAsisst, Cookies, SecurityAssist, UniversalEmail....

when uploading live, you only need to change the connection details in the connections folder.