Now you can create "SQL shim" plugins (SHOW PASSWORD is implemented in plugin/sql_shim) and install them in the server like regular plugins:
-- command doesn't work mysql> show password; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password' at line 1 -- install the example sql_shim plugin: mysql> install plugin sql_shim soname 'sql_shim.so'; Query OK, 0 rows affected (0.00 sec) -- now the command works mysql> show password; +--+ | | +--+ | | +--+ 1 row in set (0.00 sec)
There can be only one!
There may only be ONE "SQL shim" plugin running in the server at one time. All "SQL shim" plugins must use the plugin name "sql_shim". This prevents more than one "SQL shim" plugin from being utilized at once. This is by design, because the MySQL plugin interface doesn't make any provisions for plugin execution order. If you install a SQL shim plugin by another name, it won't cause harm, but it will not be utilized.