PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html
The value is large because it encodes the column sequence number and ordinal position. CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-multi.html
If the servers that you want to manage have different user names or passwords for the administrative accounts, you might want to create an account on each server that has the same user name and password. For example, you might set up a common ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html
MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. By default, this file is named .mysql_history and is created in your home directory. Passwords can be written as plain text in SQL ... MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
Suppose that an administrator has created the following role to confer the ability to set restricted session system variables: CREATE ROLE set_session_sysvars; GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO set_session_sysvars; Any user granted the ...(For ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions.html
create_digest(digest_type, str) Creates a digest from the given string using the given digest type, and returns the digest as a binary string. In releases from MySQL 8.0.30, MySQL Enterprise Encryption's functions are provided by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE to set up accounts and control the privileges available to each one. This change of grant table storage engine enables an accompanying ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-component.html
After writing a manifest and configuration file, you should be able to access keys that were created using the keyring_oci plugin, provided that you specify the same set of configuration options to initialize the keyring component. Prior to using ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name (col_name column_definitions) ENGINE=NDBCLUSTER; Alternatively, for an existing table that uses a different storage engine, use ALTER ...