Some of the improvements on MariaDB 10.6 from its predecessors include:

Oracle compatibility – There are ongoing works in making MariaDB compatible with OracleDB with some Oracle Syntaxes and functions already added.

OFFSET…FETCH… – WITH TIES is an optional clause that adds extra functionality.

JSON_TABLE() – can create a JSON table that can be used as a subquery from a JSON document.

SKIP LOCKED – Locked tables are skipped from being updated or selected.

sys schema supported– This is a “system” database containing views and procedures for investigating performance problems.

Ignored Indexes – These are indexes that are visible and maintained but not used by the optimizer.

One can manage MariaDB service using the Systemd. The SQL statements are case insensitive, So you can write them in any case. GRANT ALL ON *.* TO WITH GRANT OPTION Īpply the new changes, execute: FLUSH PRIVILEGES Here the GRANT OPTION allow a user to create other users and assign them permissions.

Next, grant permissions on all databases to a newly created account.

Make sure to change admin with your username and _pas$$w0rd_ with a new secure password. Now create a new user with a password in the MariaDB server. And to create a new user login to MariaDB using: sudo mysql This may cause complications therefore, it is recommended to set a new user with password-based access. Create Privileges User with Authenticationįor security purposes, MariaDB uses a unix_socket plugin to authenticate the root user. The options are self-explanatory, for the first two options choose “n” and for the next sequence of options press “y” for yes. To configure MariaDB properly we need to run a security script using the below-mentioned command: sudo mysql_secure_installationĪfter running the above command, you will be prompted with various options: Now, to install MariaDB, execute the below-mentioned command: sudo apt install mariadb-server Configure MariaDB on Debian For this tutorial, we will install MariaDB on Debian 11 system via default repositories.įirstly, update the packages list using: sudo apt update You can directly install it without adding an extra repo to your system. The MariaDB packages are available under the official repositories. This article is focusing on how to install MariaDB, an alternative to MySQL on Debian 11. MySQL is currently not available for Debian 11 Bullseye, so MariaDB is a perfect choice.

Mysql debian 11