Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which ...GRANT and REVOKE assign privileges to and revoke privileges from ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-commmitting-statements.html
(R-log-commit-statement) All other statements that have a pre-commit are written directly to the binlog. (Note: this is semantically equivalent to writing it to the SC and flushing the SC. However, due to requirements by NDB (which have not been ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The CREATE INDEX statement only finishes after all transactions that are accessing the table are completed, so that the initial state of the index reflects the most recent contents of the table. Online DDL support for adding secondary indexes means ...Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL support for index ...
https://dev.mysql.com/doc/workbench/en/wb-creating-eer-diagram.html
To create an EER diagram for the sakila database, first add an EER diagram by double-clicking the Add Diagram icon in the EER Diagrams panel to create and open a new EER Diagram editor. To add a table to the canvas, select the Catalog tab in the ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
The applications do not need to hardcode table and column names, complicated queries, and so on. When security is paramount, stored procedures keep applications from directly manipulating tables, or even knowing details such as table and column ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
The applications do not need to hardcode table and column names, complicated queries, and so on. When security is paramount, stored procedures keep applications from directly manipulating tables, or even knowing details such as table and column ...
https://dev.mysql.com/doc/workbench/en/wb-basic-foreign-key.html
This creates a foreign key in the invoice_item table, the table on the “many” side of the relationship. Select the table tool again and place another table on the canvas. First, click the invoice_item table; notice that a red border indicates ...Revert to the default mouse pointer by clicking the arrow at the top of the vertical ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin directory. The program performs such functions as creating, signing, and retiring ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-custom.html
One of the easiest ways to create a custom template is to make a copy of any existing template. The copy can be given any suitable name; for example, Custom_Basic.tpl. This is done using a suitable command-line tool, and there are also free online ... In the simplest case, a template consists of two files: a template file, which has a .tpl extension, and a special file ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
Requirements for restoring backups created with transportable tablespaces (TTS) (that is, created with the --use-tts option) are similar to those listed in Section 5.1.4, “Table-Level Recovery (TLR)”, with some differences noted in the section.