# Differences in MariaDB in Debian (and Ubuntu) The [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by MariaDB Foundation's and MariaDB Corporation's repositories are not identical to the official [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) 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](https://mariadb.com/docs/server/clients-and-utilities/server-client-software/download/getting-the-mariadb-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: * [mariadb-server](https://salsa.debian.org/mariadb-team/mariadb-server) As a consequence, MariaDB behaves a bit differently if it is installed from Debian's and Ubuntu's default repositories. ## Option File Locations * The [option file](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files) located at `/etc/mysql/my.cnf` is handled by the [update-alternatives](https://manpages.ubuntu.com/manpages/trusty/en/man8/update-alternatives.8.html) 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 [option files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files) are therefore actually located in `/etc/mysql/mariadb.d/`. ## System Variables Since [MariaDB 11.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.6/what-is-mariadb-116) there is no system variable difference from the Standard MariaDB. | Variable | MariaDB in Debian | Standard MariaDB | Notes | | -------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [character\_set\_server](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_server) | utf8mb4 | latin1 (for <= [MariaDB 11.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.5/what-is-mariadb-115)) | [MariaDB 11.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.6/what-is-mariadb-116) also defaults to utf8mb4 hence no difference for this version and greater | | [collation\_server](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#collation_server) | utf8mb4\_general\_ci (for < [MariaDB 11.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.5/11.5.2)) | latin1\_swedish\_ci | [character\_set\_collations](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#character_set_collations) has dominant effect hence removal from Debian default settings | ## Options | Option | MariaDB in Debian | Standard MariaDB | Notes | | ------------------------------------------------------------------------------------------------------------------- | ----------------- | ---------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [plugin-load-add](https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options) | auth\_socket.so | - | Before [MariaDB 10.4.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.4/10.4.3), MariaDB did not enable the [unix\_socket](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-unix-socket) authentication plugin by default.This is default in Debian, allowing passwordless login. | ## TLS * MariaDB binaries from [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by Debian's and Ubuntu's default repositories are linked with a different TLS library than MariaDB binaries from [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by MariaDB Foundation's and MariaDB Corporation's repositories. * MariaDB Server binaries: * MariaDB Server is statically linked with the bundled [wolfSSL](https://www.wolfssl.com/products/wolfssl/) libraries in [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by Debian's and Ubuntu's default repositories. * In contrast, MariaDB Server is dynamically linked with the system's [OpenSSL](https://www.openssl.org/) libraries in [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by MariaDB Foundation and MariaDB Corporation. * MariaDB [client and utility](https://mariadb.com/docs/server/clients-and-utilities) binaries: * MariaDB's [clients and utilities](https://mariadb.com/docs/server/clients-and-utilities) and [MariaDB Connector/C](https://app.gitbook.com/s/CjGYMsT2MVP4nd3IyW2L/mariadb-connector-c) are dynamically linked with the system's [GnuTLS](https://www.gnutls.org/) libraries in [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by Debian's and Ubuntu's default repositories. [libmysqlclient](https://dev.mysql.com/doc/refman/5.5/en/c-api.html) is still statically linked with the bundled [wolfSSL](https://www.wolfssl.com/products/wolfssl/) libraries. * MariaDB's clients and utilities and [MariaDB Connector/C](https://app.gitbook.com/s/CjGYMsT2MVP4nd3IyW2L/mariadb-connector-c) are dynamically linked with the system's [GnuTLS](https://www.gnutls.org/) libraries in [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by Debian's and Ubuntu's default repositories. [libmysqlclient](https://dev.mysql.com/doc/refman/5.5/en/c-api.html) is still statically linked with the bundled [yaSSL](https://www.wolfssl.com/products/yassl/) libraries. * In contrast, MariaDB's clients and utilities, [libmysqlclient](https://dev.mysql.com/doc/refman/5.5/en/c-api.html), and [MariaDB Connector/C](https://app.gitbook.com/s/CjGYMsT2MVP4nd3IyW2L/mariadb-connector-c) are dynamically linked with the system's [OpenSSL](https://www.openssl.org/) libraries in [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) packages provided by MariaDB Foundation's and MariaDB Corporation's repositories. * See [TLS and Cryptography Libraries Used by MariaDB](https://mariadb.com/docs/server/security/encryption/tls-and-cryptography-libraries-used-by-mariadb) for more information about which libraries are used on which platforms. ## Authentication * The [unix\_socket](https://github.com/mariadb-corporation/mariadb-docs/blob/main/server/server-management/reference/plugins/authentication-plugins/authentication-plugin-unix-socket.md) authentication plugin is installed by default in new installations that use the [.deb](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files) 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 [mariadb-install-db](https://mariadb.com/docs/server/clients-and-utilities/deployment-tools/mariadb-install-db) will also be created to authenticate via the [unix\_socket](https://mariadb.com/docs/server/reference/plugins/authentication-plugins/authentication-plugin-unix-socket) authentication plugin in these builds. ## See Also * [Moving from MySQL to MariaDB in Debian 9](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/troubleshooting-installation-issues/installation-issues-on-debian-and-ubuntu/moving-from-mysql-to-mariadb-in-debian-9) ## More Information For details, check out the Debian and Ubuntu official repositories: * [search?keywords=mariadb-server\&searchon=names\&suite=all§ion=all](https://packages.debian.org/search?keywords=mariadb-server\&searchon=names\&suite=all%C2%A7ion=all) * [search?keywords=mariadb-server\&searchon=names\&suite=all§ion=all](https://packages.ubuntu.com/search?keywords=mariadb-server\&searchon=names\&suite=all%C2%A7ion=all) *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}