Search Results
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
https://dev.mysql.com/doc/refman/8.4/en/connecting.html
This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump. For information on establishing connections using URI-like connection strings or key-value ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
Rather, the password supplied by a user who is attempting to connect is encrypted (using the password hashing method implemented by the account authentication plugin). When you attempt to connect to a MySQL server, the server accepts or rejects the ...
https://dev.mysql.com/doc/refman/8.4/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
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-temporary-table.html
You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. This means that two different sessions can use the same temporary table ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL accounts. This section describes how to assign a password to the initial root account created during ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
The log_filter_internal log filter component implements a simple form of log filtering based on error event priority and error code. To affect how log_filter_internal permits or suppresses error, warning, and information events intended for the ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify the log_error_services value. The following example enables ...