What problem does it solve? LLMs frequently generate incorrect MariaDB account-management SQL — such as treating a bare string in SET PASSWORD as cleartext, omitting the DAY unit in PASSWORD EXPIRE INTERVAL, or assuming IDENTIFIED VIA merges rather than replaces authentication plugins. This Skill provides the exact MariaDB-specific syntax and behavioral deltas needed to write correct ALTER USER and SET PASSWORD statements. ## Core Features & Use Cases - Password semantics correction: Explains the three SET PASSWORD literal forms (PASSWORD(), OLD_PASSWORD(), pre-hashed string) and why there is no cleartext bare-string form. - Full ALTER USER option surface: Covers IF EXISTS warning semantics, IDENTIFIED BY vs IDENTIFIED BY PASSWORD vs IDENTIFIED VIA/WITH multi-plugin auth, PASSWORD EXPIRE variants, ACCOUNT LOCK/UNLOCK, TLS/REQUIRE options, and resource limits. - Behavioral edge cases: Details sandbox mode for expired passwords, lock-check ordering before credential validation, and default_password_lifetime being disabled by default. - Use Case: When asked to rotate a user's password or enforce 90-day expiry on MariaDB 11.8, generate ALTER USER 'app'@'%' IDENTIFIED BY 'newpass' PASSWORD EXPIRE INTERVAL 90 DAY; instead of the common incorrect forms. ## Quick Start Ask the AI to write or review a MariaDB statement that changes a user's password, expires credentials, or locks an account, and it will apply the correct MariaDB syntax.
