Knowledge Base FAQ Item #7760225

Q7760225: On generating a Graph, we get error 20005: "Unable to open database connection. Client does not support authentication protocol requested by server; consider upgrading MySQL client". How can we fix this error?

MySQL versions from 4.1x upwards use a different algorithm to hash passwords than the pre 4.1 versions. If your client does not implement this algorithm, it’s possible you will get this error when you try to connect.

In your MySQL shell, type the command below:

ALTER USER 'myaccount'@'myhost' IDENTIFIED WITH mysql_native_password by 'mypassword';

Where myaccount is the database-account, myhost is the hostname or IP address of the MySQL server, and mypassword is the root password for the database. For example:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'topsecret';

(viewed: 2551)