Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench incompatible/nonstandard server

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

like image 900
D. Coop Avatar asked Feb 13 '16 04:02

D. Coop


People also ask

Can MySQL Workbench work without MySQL server?

General Requirements MySQL server: Although it is not required, MySQL Workbench is designed to have either a remote or local MySQL server connection.

Could not connect server may not be running in MySQL Workbench?

Here are some reasons the Can't connect to local MySQL server error might occur: mysqld is not running on the local host. Check your operating system's process list to ensure the mysqld process is present. You're running a MySQL server on Windows with many TCP/IP connections to it.

How do I fix SSL connection error in MySQL?

right-click on the particular MySQL instance and select "Edit Connection" Select the "SSL" tab under Connection Method. Select the drop-down for the "Use SSL" and choose "If Available" instead of "Required". Click the "Test Connection" button at the lower right connection to make sure you can now connect without errors ...


1 Answers

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.

like image 89
Ankit Pandey Avatar answered Sep 17 '22 16:09

Ankit Pandey