Connect from the MySQL Client
On this page
You can use the command-line MySQL client to connect to the MongoDB Connector for BI.
Connect from MySQL without Authentication or TLS/SSL
To connect to a mongosqld instance listening on the MySQL
default port 3307, run the following command:
Connect from MySQL with Authentication
Install the C Authentication Plugin as described in C Authentication Plugin.
Important
The C Authentication plugin was developed against MySQL 5.7.X Community Edition (64-bit), and tested with MySQL 5.7.X Community Edition and the latest version of MongoDB Connector for BI. The plugin is not compatible with MySQL Server or Connector/ODBC driver version 8 and later.
The following example uses the C authentication plugin to
connect to a mongosqld instance listening on port
3307 as user reportsUser. The MySQL shell prompts for the
password after the command has been entered.
For additional options, see the MySQL Commands.
Connect from MySQL with Authentication and TLS/SSL
Important
The binary distribution of MySQL Community uses the yaSSL SSL library to encrypt connections. MySQL Enterprise uses OpenSSL which is compatible with MongoDB Connector for BI. Use MySQL Enterprise to connect to BI Connector over TLS / SSL.
To connect to a mongosqld instance listening on port 3307,
as user grace using authentication mechanism PLAIN, and using
specific TLS/SSL CA and x.509 certificates, run the following command:
If using the $external authentication source, wrap your username in
single quotes or escape the $ character with a backslash to prevent
your shell from performing interpolation.
Authentication requires your client to send your password in plain text. To send the password in plain text, either:
Use the
--enable-cleartext-pluginoption shown in the previous example, orSet the environment variable
LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1.
For additional options, see the MySQL Commands.
See the MySQL documentation for additional details on enabling the MySQL cleartext plugin.