Having talked about the features in the MySQL 5.5 branch—both Server Services and the Audit Plugin API are present in the latest MySQL 5.5.4-m3 release—it is time to look into the more distant future. Authentication plugins first appeared in MariaDB—the extended version of MySQL, developed independently as a fork—version 5.2. The code was contributed to MySQL though, and may appear in a post-5.5 release.
An authentication plugin is specified per user, in the
CREATE USER or
CREATE USER serg IDENTIFIED VIA three_attempts USING 'secret'; GRANT USAGE ON *.* TO ''@'%' IDENTIFIED VIA ldap;
The second statement specifies a plugin to use for an anonymous user, it means that if the username was not found ...