Incompatible/nonstandard server version or connection protocol detected (10.8.3).
When I tried to connect to the docker's db server, as instructed, using the mysqlworkbench, I got the following warning. I got this same warning when testing the connection also. Does this have to do with the MariaDB, instead of MYSQL in docker?
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
Link to content: PHP & MySQL: Novice to Ninja, 7th Edition - Section 3
I think you’re right. From the book:
MariaDB is a drop-in replacement for MySQL, and any tutorials you follow that teach you how to use MySQL will work exactly the same way with MariaDB. As a PHP developer, you won’t notice any difference between the two, and it’s possible to swap one out for the other.
It’s possible that that statement no longer holds true - or at least, Oracle is attempting to convey the notion that the differences are too significant for MySQL Workbench.
I suspect that, despite the warning, it will work just fine. However if you wish to play it safe, you could stop the database container, change the
image: mariadb:latest line in your docker-compose.yml file to
image: mysql:latest, and run
docker-compose up to switch to a MySQL container. That should hopefully get rid of the warning.
It probably goes without saying, but make sure you have a backup of anything in the mysqldata volume that you wish to keep before making the change (eg. with
mysqldump), so you can re-import it into MySQL after the switch (or recover if you wish to roll back).
thanks for your help @boltronics . I’ll try this
I had the same issue, I manged to get it to connect but then was unable to add tables. Everything i have read about it online so far seem to indicate it no longer works with mariadb. Hopefully the fix here will work.
MySQL Workbench is valiating that it is connecting to a version of mysql it recognises. It doesn’t so it gives a warning message. Just press ok and continue as normal.