ActiveXperts Knowledge Base Article 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';

---

Contact Support

If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using the Contact Support form:
Contact Support »