I made some improvements to the 'proxy' inside of MySQL 5.7 that
I've created for WarpSQL (Shard-Query 3). I've made the
MySQL proxy/shim pluggable and I moved the SQLClient to
sql/sql_client.cc. I've merged these changes into 'master'
in my fork.
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)