MySQL connection problem

[Eiolon]

I get this error when trying to connect to a MySQL database in Dreamweaver 8:

MySQL Error #: 1251

Client does not support authentication protocol requested by server; consider upgrading MySQL client.

It directs me to:

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=c45f8a29

I am not using 4.1 but rather 5.0.21. I never upgraded from 4.1, this is a fresh install. Thanks for your help.

[Newsgroup_User]

Eiolon wrote:
> I am not using 4.1 but rather 5.0.21. I never upgraded from 4.1, this is
> a fresh install. Thanks for your help.

What it means is that the "client" is old, not your installation of
MySQL. Assuming that you are running MySQL with PHP on Windows, it means
that the MySQL Client API Version in PHP is designed for MySQL 4.

It depends how you installed PHP, but the answer lies in getting Windows
to read the correct version of libmysql.dll. If you installed PHP the
old way by copying files to your Windows and Windows\system32 folders,
copy libmysql.dll from the MySQL bin folder to Windows\system32.

If you installed PHP the recommended way (by adding the PHP folder to
your Windows PATH), delete the version of libmysql.dll in the
Windows\system32 folder. Also make sure that you are running PHP 5, with
mbstring and mysqli enabled.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/