PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
Summary of the procedure for adding a new user-defined collation: Choose a collation ID. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
The AUDIT_ABORT_EXEMPT privilege is also assigned to existing accounts with the SYSTEM_USER privilege when you carry out an upgrade procedure with MySQL 8.0.28 or later, if no existing accounts have that privilege assigned. For information about ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
For additional information about InnoDB backup procedures, see Section 17.18.1, “InnoDB Backup”. It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system ...
https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html
These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a number of platforms, and binaries in platform-specific package formats for selected platforms. This section covers the installation ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
There are two ways to address this problem: Reduce the number of TCP ports consumed quickly by investigating connection pooling or persistent connections where possible Tune some settings in the Windows registry (see below) Important The following ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
Important A replica set up with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS on any channel cannot be promoted to replace the replication source server in the event that a failover is required, and a backup taken from the replica cannot be used to restore ...] CHANGE MASTER TO changes the parameters that the replica server uses for connecting to the source and for reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
Important A replica set up with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS on any channel cannot be promoted to replace the replication source server in the event that a failover is required, and a backup taken from the replica cannot be used to restore ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To update the tables to the expected structure, perform the MySQL upgrade procedure. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. GRANT and REVOKE assign ...
https://dev.mysql.com/doc/refman/8.0/en/creating-rsa-files-using-openssl.html
Note There are easier alternatives to generating the files required for RSA than the procedure described here: Let the server autogenerate them or use the mysql_ssl_rsa_setup program (deprecated as of MySQL 8.0.34). This section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...