User Account Management

Master user account management in MariaDB Server. This section covers creating, modifying, and revoking user privileges to ensure secure and controlled access to your databases.

Roles

Manage roles in MariaDB Server for streamlined user access control. This section explains how to create, assign, and manage roles to simplify privilege management and enhance security.

Account Locking

Explains how to lock and unlock user accounts using CREATE USER and ALTER USER statements to prevent login access without deleting the account.

Authentication

Details the authentication changes introduced in MariaDB 10.4, including multiple authentication plugins per user, the mysql.global_priv table, and the default unix_socket authentication for root.

Incrementing of the access_denied_errors Status Variable

Describes the conditions that trigger the access_denied_errors status variable, such as failed logins, invalid privileges, or missing SSL requirements, aiding in security monitoring.

User Password Expiry

Guide to configuring password expiration policies, including setting global lifetimes via default_password_lifetime or per-user limits, and handling expired password connections.

Catalogs

Introduction to Catalogs, a multi-tenancy feature for isolating database objects and users, planned for future MariaDB releases.

_{This page is licensed: CC BY-SA / Gnu FDL}