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/keyring-file-component.html
To use component_keyring_file for keystore management in the most common scenario, create two files: a manifest file that tells the server to load component_keyring_file, and a configuration file that specifies where to store the keys. Verify ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. ndb-connectstring=management_host[:port] ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster ...
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/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/8.0/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
For Unicode character sets, the xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug #27877). The following table shows the ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
Local cloning operations do not support cloning of general tablespaces that were created with an absolute path. Before 8.0.37, the point release number also had to match, so cloning the likes of 8.0.36 to 8.0.42 or vice-versa is not permitted Prior ... The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html
By default, a remote cloning operation removes existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory before cloning data from the donor. Cloned data is a physical snapshot of data stored in ...