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:
- Invalid authorization specification message from server.
- 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. ...Authentication Methods in Applications Manager
Authentication involves validating an incoming user to facilitate the access to a specific resource. There are various authentication methods that you can use - based on the requirements and usage. In recent times, numerous organizations are ...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 ...How to fix "Connections using insecure transport are prohibited while --require_secure_transport=ON" in MySQL?
Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON Reason: This error occurs when the user is trying to add a SSL-supported monitor(i.e --require_secure_transport option enabled) as a non-SSL ...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 ...