The MongoDB Connector for Business Intelligence for Atlas and on-premises reaches end-of-life (EOL) and will no longer be supported after September 2026. For all new projects, we recommend using the new MongoDB SQL Interface to connect to Atlas or Enterprise Advanced deployments. The SQL Interface offers improved performance, a simplified setup, and enhanced features. To learn more, see Connect With SQL.
The following table lists some mysql command-line options available
for use with the C Authentication Plugin, mongosql_auth.
Uses the C Authentication plugin. If you are using a MySQL
option file, specify the following configuration to use the
mongosql_auth plugin:
[client]
default-auth=mongosql_auth
To use an option file with an
ODBC DSN, add the
USE_MYCNF=1 connection parameter to the
DSN.
--user
<your-username>
Possible parameters to this option are
source=<authenticated-db> and
mechanism=<auth-mechanism>. If no authenticated database
is specified, it defaults to admin. If no authentication
mechanism is specified, it defaults to SCRAM-SHA-1.
If you use both the source and mechanism parameters,
separate them with a & and enclose the entire option in
single quotes. For example: