Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

MySQL connection problem

New Here ,
May 25, 2006 May 25, 2006
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.
TOPICS
Server side applications
275
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 25, 2006 May 25, 2006
LATEST
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/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines