How to fix "Client does not support authentication protocol requested by server; consider upgrading MySQL client"?

How to fix "Client does not support authentication protocol requested by server; consider upgrading MySQL client"?

Error Message:
Data source rejected establishment of connection message from server: "Client does not support authentication protocol requested by server; consider upgrading MySQL client
Reason: The Client does not support authentication protocol error can occur when the user trying to add the latest mysql server using old mysql connector in Applications Manager.

Solution: To update the latest mysql connector, you can follow these steps:
  • If the .jar file is not present, you can download it from here (for MYSQL versions older than 5.6) or here (for MYSQL version 5.6 and newer).
  • Extract the downloaded zip file.
  • Find mysql-connector-java-3.0.10-stable-bin.jar or mysql-connector-java-5.1.46.jar file and rename the file as mysql_connector.jar
  • In the machine, where Applications Manager is running, copy the downloaded mysql_connector.jar to <Applications Manager Home>/working/mysql/MMMySQLDriver/ directory.
  • Restart Applications Manager.
For the following issues also solution is same:
  1. Invalid authorization specification message from server.
  2. Unknown character set index for field '255' received from server.


                  New to ADSelfService Plus?

                    • Related Articles

                    • How can I upgrade the MySQL connector.jar?

                      For all the following issues mentioned below, the solution is same. Invalid authorization specification message from server. Unknown character set index for field '255' received from server. Communication link failure: javax.net.ssl.SSLException. ...
                    • Mail Server Monitor - Troubleshooting

                      Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...
                    • How to view data under Session & Performance tab in MySQL monitor?

                      Note: If the server is a MariaDB server, check whether the SYS database is installed by executing the below query on MariaDB shell: show databases; If the output does not contain the SYS database, then install the SYS database suitable for the ...
                    • Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers

                      Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON Solution: To overcome this issue follow the steps given below: Execute the following query in the corresponding MySQL shell script: ALTER USER ...
                    • How to fix "Communication link failure The last packet sent successfully to the server"?

                      Issue: Communication link failure error message will trigger based on many reasons. Solution: Communication link failure error message is shown due to various reasons. Follow any of the steps mentioned below to resolve the issue: Insufficient user ...