Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
The following Account Management statements: GRANT, REVOKE, RENAME USER, CREATE ROLE, CREATE USER, DROP ROLE, DROP USER, SET PASSWORD, SET ROLE, SET DEFAULT ROLE. The following database administration statements: SHOW CREATE..., SHOW VARIABLES, SHOW ... The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not followed by UPDATE or ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-data-adapter.html
Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly closed. A connection could then be reestablished only if and when the application writes data back to the database. The Data Adapter ...It is also possible to work in a manner where a connection is only established when ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access-linked-tables.html
You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. When a query is requested on a table within Access, ODBC is used to execute the queries on ...Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN you want to link your table ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data-adapter.html
Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly closed. A connection could then be reestablished only if and when the application writes data back to the database. The Data Adapter ...It is also possible to work in a manner where a connection is only established when ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. When a query is requested on a table within Access, ODBC is used to execute the queries on ...Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN you want to link your table ...
https://dev.mysql.com/doc/mysql-em-plugin/en/targets-myoem-add-targets-manually.html
Metrics are not collected until the MySQL database is added as a target. Note When adding a MySQL database target, if the plugin is not deployed on the host selected, the system automatically deploys the plugin to the Management Agent on the target ... You must configure a MySQL target that is monitored by Enterprise Manager Cloud ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-agent-gui-ref.html
TCP/IP: select if the agent uses TCP/IP to connect to the monitored database. Socket: select if the agent uses socket to connect to the monitored database. This is only possible if the agent is monitoring a local database. If you select host and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
By default, all the files under the database subdirectories in the data directory are included in the backup, so that the backup includes data from all MySQL storage engines, any third-party storage engines, and even any non-database files in that ...This section explains options you can use to selectively back up or exclude ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
The example here uses the Linux installation script and the default mysql system database. $> mysql -u root -p -D mysql < audit_log_filter_linux_install.sql Enter password: (enter root password here) It is possible to specify a custom database for ... This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 8.4.5.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
To drop an index, right-click the index name and then click the Delete Selected menu item. The Indexes subtab contains all of the index information for your table. The following figure shows an example of the layout with the PRIMARY index of the ...