PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
Note The OWNER option is currently not applied, and has no effect on the ownership or operation of the server connection that is created. For example: CREATE SERVER s FOREIGN DATA WRAPPER mysql OPTIONS (USER 'Remote', HOST '198.51.100.106', DATABASE ... 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 character-literal | PORT numeric-literal } This statement creates the definition of a server for use with the FEDERATED storage ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
Note Older versions of MySQL used a COMMENT option for the connection string. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
MYSQL_UNIX_PORT The default Unix socket file name; used for connections to localhost. MYSQLX_UNIX_PORT The X Plugin default Unix socket file name; used for connections to localhost. USER The default user name on Windows when connecting to mysqld.
https://dev.mysql.com/doc/refman/8.0/en/flush.html
This enables the flush operations to be performed without having to connect to the server, which requires a MySQL account that has privileges sufficient for those operations. It also resets the counters for key caches (default and named) to zero and ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
Connect to the target host (the host for s3 in this case), and restore the backup using MySQL Enterprise Backup. Connect to the target host (the host for s3 in this case), and restore the backup using MySQL Enterprise Backup. MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ipv6.html
IPv6 addresses, or host names that resolve to them, can be specified as the network address that the member provides in the group_replication_local_address option for connections from other members. If a host name specified as the Group Replication ... As of MySQL 8.0.14, Group Replication group members can use IPv6 addresses as an alternative to IPv4 addresses for communications within the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
A detached transaction is one which, once prepared, is no longer connected to the current session. The prepared XA transaction can be committed or rolled back by another connection, and the current session can then initiate another XA transaction or ... Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-exit.html
Note that in the case of an expelled member, the member does not know that it was expelled until it reconnects to the group, so the specified action is only taken if the member manages to reconnect, or if the member raises a suspicion on itself and ... The group_replication_exit_state_action system variable, which is available from MySQL 8.0.12 and MySQL 5.7.24, specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
To upgrade a member of a group: Connect a client to the group member and issue STOP GROUP_REPLICATION. Disable Group Replication from starting up automatically so that you can safely connect to the member after upgrading and configure it without it ... This section explains the steps required for upgrading a member of a ...