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.