连接到MariaDB时MySQL Workbench警告

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了连接到MariaDB时MySQL Workbench警告，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2611字，纯文字阅读大概需要4分钟。

内容图文

在Kubuntu 15.10和MariaDB Server版本：10.0.22-MariaDB-0ubuntu0.15.10.1(Ubuntu)上使用MySQL Workbench 6.3时,我收到以下警告.

这是预期的吗？

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

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

Succcessfully made the mysql connection

Information related to this connection:

Host: localhost Port: 0 User: serg SSL: not enabled

A successful MySQL connection was made with the parameters defined for
this connection.

解决方法:

TL; DR
是的,这是预料之中的,因为MySQL Workbench是一个Oracle产品,并且它没有正式支持实际上是MySQL竞争对手的MariaDB. Workbench警告您可能存在不兼容性,不一定是检测到的不兼容性.在大多数情况下,可以安全地忽略它.

细节

MariaDB knowledge-base article on MySQL compatibility describes the relationship best(强调我的)：

For all practical purposes, MariaDB is a binary drop in replacement of the same MySQL version (for example MySQL 5.1 -> MariaDB 5.1, MariaDB 5.2 & MariaDB 5.3 are compatible. MySQL 5.5 is compatible with MariaDB 5.5 and also in practice with MariaDB 10.0). What this means is that:

• Data and table definition files (.frm) files are binary compatible.
  • See note below for an incompatibility with views!
• All client APIs, protocols and structs are identical.
  All filenames, binaries, paths, ports, sockets, and etc… should be the same.
• All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.
  • There are some installation issues with PHP5 that you should be aware of (a bug in how the old PHP5 client checks library compatibility).
• The mysql-client package also works with MariaDB server.
• The shared client library is binary compatible with MySQL’s client library.

This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go. (No need to convert any datafiles if you use same main version, like 5.1). You must however still run mysql_upgrade to finish the upgrade. This is needed to ensure that your mysql privilege and event tables are updated with the new fields MariaDB uses.

We do monthly merges with the MySQL code base to ensure we keep up our compatibility and get any and all features and bug fixes Oracle adds.

所有这一切,都存在一些可能会或可能不会影响您的不兼容性.链接的知识库文章有一节介绍不同版本的MySQL和MariaDB之间的已知不兼容性.有关可能对您有影响的注意事项,请参阅MariaDB版本的部分.

内容总结

以上是互联网集市为您收集整理的连接到MariaDB时MySQL Workbench警告全部内容，希望文章能够帮你解决连接到MariaDB时MySQL Workbench警告所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端