PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-installation.html
To avoid this overhead, do not install it unless you plan to use it. This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, called the view ... Some ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
Full backups are necessary, but it is not always convenient to create them. If you make sure to flush the logs when you make your full backup, the binary log files created afterward contain all the data changes made since the backup. On Monday at 1 ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf16.html
For a supplementary character, utf16 has a special sequence for representing the character using 32 bits. The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
The table can be accessed freely by the session within which it was created, regardless of what other locking may be in effect. The following statements are prohibited while a LOCK TABLES statement is in effect: CREATE TABLE, CREATE TABLE ... LIKE, ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.0/en/log-file-maintenance.html
As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking place. A log-flushing operation has the following effects: If binary logging is enabled, the server ...
https://dev.mysql.com/doc/refman/8.0/en/memory-use.html
For MEMORY tables explicitly created with CREATE TABLE, only the max_heap_table_size system variable determines how large a table can grow, and there is no conversion to on-disk format. When reading rows in an arbitrary sequence (for example, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-client-commands.html
Commands for the event logs are given in Section 25.6.3, “Event Reports Generated in NDB Cluster”; commands for creating backups and restoring from them are provided in Section 25.6.8, “Online Backup of NDB Cluster”. CREATE NODEGROUP ... In ...
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]] ...