Thanks .. you probabaly know that I am not a developer rmyself (I basically
stopped being so when ALGOL died 35 years ago!). I have shared all
information with SQLyog developer team and we will look into this again.
-- Peter
On Mon, Oct 13, 2014 at 9:17 PM, Sergei Golubchik
Hi, Peter!
On Oct 13, Peter Laursen wrote:
To make it clear: it is not acceptable/not a usable solution for us if it is a requirement that a MariaDB server is installed on user's system. The client (in case SQLyog - but it could be any client) should work for connection to remote servers with no server at all installed on client machine.
Yes, I understand (and agree!).
MariaDB server is not needed. You only need mysql_clear_password.dll that is put in the location where the client library expects it to. And you can set this location with
mysql_options(..., MYSQL_PLUGIN_DIR, "path");
Another option would be to compile the plugin into SQLyog. It's doable too, but you need the source for the plugin (because it's not part of the libmysqlclient). Luckily, the whole source of the plugin is:
========================================================= static int clear_password_auth_client(MYSQL_PLUGIN_VIO *vio, MYSQL *mysql) { int res= vio->write_packet(vio, (const unsigned char *) mysql->passwd, strlen(mysql->passwd) + 1); return res ? CR_ERROR : CR_OK; }
mysql_declare_client_plugin(AUTHENTICATION) "mysql_clear_password", "Georgi Kodinov", "Clear password authentication plugin", {0,1,0}, "GPL", NULL, NULL, NULL, NULL, clear_password_auth_client mysql_end_client_plugin; =========================================================
If you want it to be part of SQLyog, you put this code somewhere and call
mysql_client_register_plugin(MYSQL*, _mysql_client_plugin_declaration_);
Then you won't need a separate mysql_clear_password.dll
Regards, Sergei