PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. To create or modify ...Invoke mysqladmin like this: mysqladmin [options] command [command-arg] [command [command-arg]] ...
https://dev.mysql.com/doc/refman/8.0/en/network-namespace-support.html
(For example, Linux.) Any network namespace to be used by MySQL must first be created on the host system. If errors occur for X Plugin during plugin initialization such that it is unable to bind to any address, the plugin fails its initialization ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-ddl-operations.html
Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE and CREATE TABLE might be fastest. Many DDL operations on tables and indexes (CREATE, ALTER, and DROP ...Use TRUNCATE TABLE to empty a table, not DELETE FROM ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
ARRAY is not supported except when used to create a multi-valued index in one of these statements, in which case it is required. Note CONVERT(), unlike CAST(), does not support multi-valued index creation or the ARRAY keyword. Other Uses for Cast ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Note Due to the advantages of group profiles over account profiles, and because a group profile with a single member account is logically equivalent to an account profile for that account, it is recommended that all new firewall profiles be created ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
The following example demonstrates creating and configuring a new global stopword table for InnoDB. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html
For example, plugins can be created to use external authentication methods such as PAM, Windows login IDs, LDAP, or Kerberos. The Default Authentication Plugin The CREATE USER and ALTER USER statements have syntax for specifying how an account ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. Before MySQL 8.0, to create the replication metadata repositories as tables, it was necessary to specify ...If ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. For example, to manage execution of ...Group attributes enable control over its resources, to enable or restrict resource consumption by threads in the ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. Stored function: An object created with CREATE FUNCTION and used much like a built-in function. Trigger: An ...