MySQL Workbench incompatible/nonstandard server

mysql workbench
D. Coop picture D. Coop · Feb 13, 2016 · Viewed 71.2k times · Source

I am new to using MySQL and I needed to download it for school, however, I keep getting this error message (picture below). I am using xampp and connecting using the username root. the port also matches what it is telling me. It will let me proceed but a lot of the features are missing. Any help at all would be appreciated.

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

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.1, 5.5, 5.6 and 5.7

PICTURE HERE

Answer

Ankit Pandey picture Ankit Pandey · Oct 18, 2017

As I can see, You are using latest XAMPP.

All you need to do is, after opening MySQL Workbench, and instead of setting up a new connection, Press CTRL+R or click on DATABASE tab in the top menu. Select Reverse Engineer and provide necessary information. You are good to go now.

The MySql workbench wont crash or show any compatibility issue now.

Related questions

Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More
Export dump file from MySql

I want to create a dump file of a table in the database. So database --> king, tablename --> castle So what I want to do is create a dump file.. and then the next part is to …

Read More
MySQL Workbench charset

Does there exist any way to change the MySQL Workbench charset? My schema uses UTF-8 and when I view the table data (saved as UTF-8) or add data manually, it appears with charset errors, probably MySQL Workbench uses LATIN1.

Read More