Client does not support authentication protocol requested by server

Client does not support authentication protocol requested by server; consider upgrading MySQL client

      

Root Cause of the Error:
This issue mainly occurs when multiple versions of MySQL are installed on the machine, causing conflicts within the database. Additionally, there are conflicts with the SQL Connector based on the database available on the system.

Solution:
Before making any changes, it's crucial to back up your MySQL database. Save the backup to a secure location.

Process 1 → If no other software is using MySQL database :
  1. Open the Control Panel and go to "Add/Remove Programs" (Windows) or "Programs and Features" (Windows 10/11).
  2. Locate MySQL (version higher than 4.0.13 or any other version) in the list of installed programs and uninstall it.
  3. After uninstallation, ensure that all MySQL services are stopped and removed:
    1. Press Win + R, type services.msc, and press Enter.
    2. Locate any MySQL-related services (e.g., MySQL, MySQL Server, MySQL56) in the list.
    3. Stop and disable these services by right-clicking on each service, selecting "Stop," and then "Properties" to set the startup type to "Disabled."
  4. Use the "C:\mysql\bin\winmysqladmin.exe" tool to manage any remaining MySQL services:
    1. Open File Explorer and navigate to C:\mysql\bin.
    2. Double-click winmysqladmin.exe to launch the MySQL Administrator.
    3. Check for any remaining MySQL services and take appropriate actions (e.g., stopping or removing them).

Process 2 → If other software is using MySQL :

Change MySQL Port: To prevent conflicts with other software using MySQL, change the port number of your MySQL application (e.g., from 3306 to 3307). 
Follow these steps: MySQL Port Change Process

Following these steps should resolve the connection issue and ensure the proper functioning of your MySQL server and application.

    • Related Articles

    • MySQL server has gone away

      Root Cause of the Error → The "MySQL server has gone away" error can be attributed to several potential causes related to connection issues and server configurations. These include: Server Timeout → The MySQL server may close the connection if it ...

    • Can't connect to MySQL server on 'LOCALHOST' (10061)

      MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. KDK Software uses MySQL as its back-end ...

    • Lost connection to MySQL Server during Query

      Root Cause of the Error The "lost connection to MySQL server during query" error typically occurs when the SQL server times out. This can be due to various factors such as a remote server with poor network connectivity or heavy network traffic. ...

    • ERROR Of SQL Server OLEDB Provider support

      Problem: Encountering a SQL Server OLEDB provider support error while accessing a Windows application, with the error message: "Unable to load SQL Server OLEDB provider resource DLL. The application cannot continue". Solution: Open File Explorer: ...

    • Income Tax || Client Search

      If you encounter any issues while searching for the client, please follow these steps: Step 1: Navigate to the root directory of the software. This could be either "C:\Program Files (x86)\K.D.K. Software\KDK Support" or "C:\Program Files\K.D.K. ...