CData Python Connector for MySQL

Build 25.0.9454

Database

Specifies the name of the MySQL database to connect to by default. This determines the active schema used for queries unless explicitly overridden.

Data Type

string

Default Value

""

Remarks

This property defines the default database (schema) that the connector connects to when establishing a connection to the MySQL Server. Set this property to limit the connection to a specific database, which can improve performance, simplify metadata discovery, and reduce accidental cross-database access.

If set, all queries operate within the context of the specified database. If not set, the connector exposes tables and views from all accessible databases on the server.

Example:

Database = "inventory"
Note: In shared environments with multiple databases, explicitly setting the Database is recommended to avoid ambiguity and ensure consistent behavior across applications.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454