A MySQL authentication plugin that implements the client-side of MongoDB-supported authentication mechanisms for the BI Connector.

Version 1.0 of this plugin will support the following mechanisms:

• SCRAM-SHA-1
• PLAIN

The plugin tarball/installer can be downloaded from the releases page.

Install the plugin using the msi installer provided on the releases page.

The plugin library (mongosql_auth.so) should be installed in <mysql home>/lib/plugin/. The default location of <mysql home> varies by platform, but the location of the plugin directory can be verified by running mysql_config --plugindir.

Alternatively, the plugin can be installed in a directory of your choice if you provide the plugin-dir=<your_install_dir> option to your MySQL client.

Optionally, specify the authentication mechanism via a query parameter on the user name. For example:

username?mechanism=PLAIN 

Optionally, specify the authentication source via a query parameter on the user name. For example:

username?source=somedb 

To authenticate with mongosqld using the mongosql_auth plugin, you will need to provide the default-auth=mongsql_auth option to your MySQL client. There are a number of ways to accomplish this, depending on which client program you are using.

With the MySQL shell, the default-auth option can be specified as follows:

mysql -uusername -ppassword --default-auth=mongosql_auth 

If you are using the MySQL ODBC driver, the interface you use to configure your DSN may provide a field where you can specify the default auth plugin to use. Specifying mongosql_auth here will cause the ODBC driver to use the mongosql_auth plugin by default.

MySQL configuration files can be found in many locations, as enumerated here. In one of these files, add a line with default-auth=mongosql_auth to the [client] section (or create it if it doesn't yet exist). To use this same configuration file with an ODBC DSN, provide the USE_MYCNF=1 connection parameter to your ODBC DSN.