Note: This page describes features in the source repository for MariaDB 10.5. There are currently no official packages or
binaries available for download which contain the features. If you want to try out any of the new features described here you will
need to get and compile the
code yourself.

MariaDB 10.5 is the current development series of MariaDB. It is an evolution
of MariaDB 10.4 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL.

Syntax

Privileges

Split SUPER privilege to smaller privileges (MDEV-21743). New privileges were added so that more fine grained tuning of what each user can do can be applied:

BINLOG ADMIN

BINLOG REPLAY

CONNECTION ADMIN

FEDERATED ADMIN

READ_ONLY ADMIN

REPLICATION MASTER ADMIN

REPLICATION SLAVE ADMIN

SET USER

The REPLICATION CLIENT privilege was renamed to BINLOG MONITOR. The old syntax is understood for compatibility (MDEV-21743).

The SHOW MASTER STATUS statement was renamed to SHOW BINLOG STATUS (MDEV-21743). The old syntax is understood for compatibility.

A number of statements changed the privileges that they require. The old privileges were historically inappropriately chosen in the upstream. 10.5.2 fixes this problem. Note, these changes are incompatible to previous versions. A number of GRANT commands might be needed after upgrade.

Contributors

Be notified of new MariaDB Server, Galera Cluster and Connector releases automatically by subscribing to the MariaDB Foundation community announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB Corporation customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB Corporation products thanks to the Notification Services.

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.