-
Book Overview & Buying
-
Table Of Contents
MySQL 5.1 Plugin Development
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 GRANT statement:
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 in the mysql.user table it will be looked up in the LDAP. This allows storage of the list of users in the LDAP without duplicating it in the MariaDB (or MySQL).
Pluggable authentication adds a new concept to the MySQL plugin architecture—client...
Change the font size
Change margin width
Change background colour