Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
It can be used to add a new data file to, or to drop a data file from an NDB tablespace. Using DROP DATAFILE with ALTER TABLESPACE drops the data file 'file_name' from an NDB tablespace. You cannot drop a data file from a tablespace which is in use ...It can also be used to rename an NDB Cluster Disk Data tablespace, rename an InnoDB general tablespace, encrypt an InnoDB general tablespace, or mark an InnoDB undo tablespace as active or ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, modifying, or dropping authentication methods for existing accounts. This can be achieved by dropping and recreating ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. You must specify the schema name if the ...
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 ...