MySQL includes a test plugin that authenticates using MySQL native authentication, but is a loadable plugin (not built in) and must be installed prior to use. It can authenticate against either normal or older (shorter) password hash values.
This plugin is intended for testing and development purposes, and not for use in production environments. The test plugin source code is separate from the server source, unlike the built-in native plugin, so it can be examined as a relatively simple example demonstrating how to write a loadable authentication plugin.
The following table shows the plugin and library file names. The
file name suffix might differ on your system. The file location
is the directory named by the
plugin_dir system variable. For
installation information, see
Section 5.8, “Pluggable Authentication”.
Table 5.7 MySQL Test Authentication Plugin
|Server-side plugin name|
|Client-side plugin name|
|Library object file name|
Because the test plugin authenticates the same way as native
MySQL authentication, provide the usual
--password options that you
normally use for accounts that use native authentication when
you connect to the server. For example:
For general information about pluggable authentication in MySQL, see Section 5.8, “Pluggable Authentication”.