Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-role.html
A role when created is locked, has no password, and is assigned the default authentication plugin. CREATE ROLE [IF NOT EXISTS] role [, role ] ... CREATE ROLE creates one or more roles, which are named collections of privileges. To use this ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
KEY_BLOCK_SIZE For MyISAM tables, KEY_BLOCK_SIZE optionally specifies the size in bytes to use for index key blocks. A KEY_BLOCK_SIZE value specified for an individual index definition overrides the table-level KEY_BLOCK_SIZE value. Storage Engine ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, FOR SHARE, LOCK IN SHARE MODE, and PROCEDURE. If the view does not exist, CREATE OR REPLACE ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
Some reserved accounts are locked and cannot be used by clients, but 'root'@'localhost' is intended for administrative use and you should assign it a password. After MySQL is installed, the data directory must be initialized, including the tables ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
The command mysqladmin debug dumps some information about locks in use, used memory and query usage to the MySQL log file. If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
Using perror, determine the error symbols: $> perror 10927 10914 1131 MySQL error code MY-010927 (ER_ACCESS_DENIED_FOR_USER_ACCOUNT_LOCKED): Access denied for user '%-.48s'@'%-.64s'. MySQL error code MY-001131 (ER_PASSWORD_ANONYMOUS_USER): You are ... The log_filter_dragnet log filter component enables log filtering based on user-defined ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
For example, you could use the GET_LOCK() function, or row or table locking. MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be ...