Knowledge Base FAQ Items

Browse "Reports and Graphs - Statistical Database / MySQL" Questions:
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 dat... Network Monitor > Reports and Graphs - Statistical Database / MySQL

Browse "Reports and Graphs - Statistical Database / MySQL" Questions:

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 dat...
Network Monitor > Reports and Graphs - Statistical Database / MySQL

ActiveXperts Error Codes

Click here to view the full list of ActiveXperts error codes

To contact the ActiveXperts Help Desk, click here.