SHOW MONGODB CONNECTIONS¶

SHOW MONGODB CONNECTIONS lists the MongoDB connections registered in the current MatrixOne account, including each connection’s authentication, TLS, and read settings.

Description¶

SHOW MONGODB CONNECTIONS returns the MongoDB connections registered with CREATE MONGODB CONNECTION for the current account. The result includes each connection’s discovery mode, authentication mechanism, TLS mode, read preference, read concern, and whether the connection is disabled.

Warning

MatrixOne v4.2.0 is missing the privilege definition for this statement. In the released v4.2.0 server, executing SHOW MONGODB CONNECTIONS fails with internal error HY000/20101 and a does not have the privilege definition panic instead of returning a result set. Do not use this statement as a connection-verification step until the server-side privilege handling is fixed.

Syntax¶

SHOW MONGODB CONNECTIONS

Arguments¶

SHOW MONGODB CONNECTIONS takes no arguments. LIKE and WHERE clauses are parsed for compatibility but are not supported at execution time. The statement lists every MongoDB connection registered for the current account.

Examples¶

SHOW MONGODB CONNECTIONS;