:: DEVELOPER ZONE
MySQL.com
Downloads
Resources
Documentation
Books
Developer Zone
Forums
Lists
Bugs
Partners
Events
Login / Register
Online Shop
User Groups
Guilds
Blogs
Support
FAQ
MySQL 5.1 Reference Manual :: A Problems and Common Errors :: A.2 Common
Errors When Using MySQL Programs :: A.2.3 Client does not support authentication protocol Overview
MySQL Reference Manual
Search the MySQL manual: Manual 5.1
Go
MySQL 5.1 Reference Manual
A.2 Common Errors When Using
MySQL Programs
A.2.1 Access denied
A.2.2 Can't connect to [local] MySQL server A.2.3 Client does not support authentication protocol
A.2.4 Password Fails When Entered
Interactively
A.2.5 Host 'host_name' is blocked
A.2.6 Too many connections
A.2.7 Out of memory
A.2.8 MySQL server has gone away
A.2.9 Packet too large
A.2.10 Communication Errors and
Aborted Connections
A.2.11 The table is full
A.2.12 Can't create/write to file
A.2.13 Commands out of sync
A.2.14 Ignoring user
A.2.15 Table 'tbl_name' doesn't exist
A.2.16 Can't initialize character set
A.2.17 File Not Found
Get the MySQL Language Reference and MySQL Administrator's Guide from
MySQL Press!
3.23, 4.0, 4.1
5.0
5.1
MaxDB Documentation
A.2.3. Client does Previous / Next / Up / Table of Contents not support authentication protocol
MySQL 5.1 uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older (pre-4.1) clients. If you upgrade the server from 4.1, attempts to connect to it with an older client may fail with the following message: shell> mysql
Client does not support authentication protocol requested by server; consider upgrading MySQL client
To solve this problem, you should use one of the following approaches:
Upgrade all client programs to use a 4.1.1 or newer client library.
When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
Reset the password to pre-4.1 style for each user that needs to