MariaDB 10.5.2 💾

MariaDB is a database server that offers drop-in replacement functionality for MySQL. It is built by some of the original authors of MySQL, with assistance from the broader community. In addition to the core functionality of MySQL, it offers a rich set of feature enhancements including alternate storage engines, server optimizations, and patches.

minor feature: RELEASE_ALL_LOCKS ( MDEV-10569 ) ALTER TABLE... RENAME INDEX / KEY ( MDEV-7318 ). ALTER TABLE... RENAME COLUMN ( MDEV-16290 ). Recursive CTE cycle detection using CYCLE clause ( MDEV-20632 ). 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 this problem. Note, these changes are incompatible to previous versions. A number of GRANT commands might be needed after upgrade. SHOW BINLOG EVENTS now requires the. BINLOG MONITOR privilege (requred. REPLICATION SLAVE prior to 10.5.2). SHOW SLAVE HOSTS now requires the. REPLICATION MASTER ADMIN privilege (required. REPLICATION SLAVE prior to 10.5.2). SHOW SLAVE STATUS now requires the. REPLICATION SLAVE ADMIN or the. SUPER privilege (required. REPLICATION CLIENT or. SUPER prior to 10.5.2). SHOW RELAYLOG EVENTS now requires the. REPLICATION SLAVE ADMIN privilege (required. REPLICATION SLAVE prior to 10.5.2). In order to help the server understand which version a privilege record was written by, the mysql.global_priv.priv field contains a new JSON field. version_id ( MDEV-21704 ). SHOW PRIVILEGES now correctly lists the. Delete history privilege, rather than displaying it as. Delete versioning rows. ( MDEV-20382 ). BINLOG ADMIN. BINLOG REPLAY. CONNECTION ADMIN. FEDERATED ADMIN. READ_ONLY ADMIN. REPLICATION MASTER ADMIN. REPLICATION SLAVE ADMIN. SET

GNU GPL database database-server database-engine mysql mariadb