Explains the differences between official Debian/Ubuntu repository packages and those from MariaDB.org, particularly regarding library linking and configuration defaults.
The .deb packages provided by MariaDB Foundation's and MariaDB Corporation's repositories are not identical to the official .deb packages provided by Debian's and Ubuntu's default repositories.
The packages provided by MariaDB Foundation's and MariaDB Corporation's repositories are generated using the Debian packaging in MariaDB's official source code. The Debian packaging scripts are specifically in the debian/ directory.
The packages provided by Debian's and Ubuntu's default repositories are generated using the Debian packaging in Debian's mirror of MariaDB's source code, which contains some custom changes. The source tree can be found here:
As a consequence, MariaDB behaves a bit differently if it is installed from Debian's and Ubuntu's default repositories.
The located at /etc/mysql/my.cnf is handled by the mechanism when the mysql-common package is installed. It is a symbolic link that references either mysql.cnf or mariadb.cnf depending on whether MySQL or MariaDB is installed. Most of the MariaDB are therefore actually located in /etc/mysql/mariadb.d/.
Since there is no system variable difference from the Standard MariaDB.
MariaDB binaries from packages provided by Debian's and Ubuntu's default repositories are linked with a different TLS library than MariaDB binaries from packages provided by MariaDB Foundation's and MariaDB Corporation's repositories.
MariaDB Server binaries:
MariaDB Server is statically linked with the bundled libraries in packages provided by Debian's and Ubuntu's default repositories.
The authentication plugin is installed by default in new installations that use the packages provided by Debian's default repositories in Debian 9 and later and Ubuntu's default repositories in Ubuntu 15.10 and later.
The root@localhost created by will also be created to authenticate via the authentication plugin in these builds.
For details, check out the Debian and Ubuntu official repositories:
This page is licensed: CC BY-SA / Gnu FDL
MariaDB client and utility binaries:
MariaDB's clients and utilities and are dynamically linked with the system's GnuTLS libraries in .deb packages provided by Debian's and Ubuntu's default repositories. libmysqlclient is still statically linked with the bundled wolfSSL libraries.
MariaDB's clients and utilities and are dynamically linked with the system's GnuTLS libraries in .deb packages provided by Debian's and Ubuntu's default repositories. libmysqlclient is still statically linked with the bundled yaSSL libraries.
In contrast, MariaDB's clients and utilities, , and are dynamically linked with the system's libraries in packages provided by MariaDB Foundation's and MariaDB Corporation's repositories.
See TLS and Cryptography Libraries Used by MariaDB for more information about which libraries are used on which platforms.
utf8mb4
latin1 (for <= )
also defaults to utf8mb4 hence no difference for this version and greater
utf8mb4_general_ci (for < )
latin1_swedish_ci
character_set_collations has dominant effect hence removal from Debian default settings
auth_socket.so
-
Before , MariaDB did not enable the unix_socket authentication plugin by default.This is default in Debian, allowing passwordless login.