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 ...

    • TAXSUIT || LAN Setting or Run Spectrum software on Server First

      When opening the TaxSuite software on a LAN machine, if you encounter issues related to LAN settings or receive an error - "Run Spectrum software on Server First". Steps for LAN Setting: NOTE: Ensure that the SERVER system is accessible from the node ...

    • 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. ...

    • 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. ...