MySQL Workbench - Connection Warning - Incompatible/nonstandard server version or connection protocol detected


Connection Warning (Local instance 3306)

Incompatible/nonstandard server version or connection protocol detected (10.4.28).

A connection to this database can be established but some MySQL Workbench features may not work properly since the database is not fully compatible with the supported versions of MySQL.

MySQL Workbench is developed and tested for MySQL Server versions 5.6, 5.7 and 8.0.

For MySQL Server older than 5.6, please use MySQL Workbench version 6.3.

MySQL Workbench - Connection Warning - Incompatible nonstandard server version or connection protocol detected

In my case, I am using a Macbook with MySQL Database running on XAMPP. What I did to fix this issue, clicked on the Cancel button and went to MySQL Workbench Menu: Database -> Reverse Engineer..,

Reverse Engineer under Database

On the window, provided the necessary details for my MySQL Server.

    Stored Connection: localhost instance 3306

    Connection Method: Standard (TCP/IP)

    Hostname: root

    Port: 3306

    Username: root

    Password: Entered from Selecting from Keystore ..

Once I clicked Continue, I got the below details.

The following tasks will now be executed. Please monitor the execution. Press Show Logs to see the execution logs.

    Connect to DBMS

    Retrieve Schema List from Database

    Check Common Server Configuration Issues

    Execution Completed Successfully

    Fetch finished.

Then i selected the schema's I wanted - test in my case.

The following tasks will now be executed. Please monitor the execution. Press Show Logs to see the execution logs.

    Retrieve Objects from Selected Schemas

    Check Results

    Retrieval Completed Successfully

    Finished.

And a few steps and I was connected to my MySQL database via the Workbench!

-

Facing issues? Have Questions? Post them here! I am happy to answer!


Author Info:

Rakesh (He/Him) is a seasoned developer with over 10 years of experience in web and app development, and a deep knowledge of operating systems. Author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap