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/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
It may be used to time how quickly MySQL processes the expression. The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); ...It is advisable to execute ...The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
ER_BAD_NULL_ERROR ER_CUT_VALUE_GROUP_CONCAT ER_DATA_TOO_LONG ER_DATETIME_FUNCTION_OVERFLOW ER_DIVISION_BY_ZERO ER_INVALID_ARGUMENT_FOR_LOGARITHM ER_NO_DEFAULT_FOR_FIELD ER_NO_DEFAULT_FOR_VIEW_FIELD ER_TOO_LONG_KEY ER_TRUNCATED_WRONG_VALUE ... The ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
To arrange for MySQL to start without manual intervention at system boot time, see Section 2.9.5, “Starting and Stopping MySQL Automatically”. Data directory initialization creates time zone tables in the mysql schema but does not populate them.
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the problem. Check to make sure that there is no firewall blocking access to MySQL. Your firewall may ...To correct this when you invoke a client program, specify a --port option to indicate the proper port number, or a --socket option to indicate the proper named pipe or Unix socket ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-native.html
Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management systems. This section provides basic ...Important Native packages are often several versions behind the currently available ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
Beginning with MySQL 8.0.22, CAST() supports retrieval of a TIMESTAMP value as being in UTC, using the AT TIMEZONE operator. Note Prior to MySQL 8.0.28, this function sometimes allowed invalid conversions of BINARY values to a nonbinary character ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
Synonym for JSON_MERGE_PRESERVE(); deprecated in MySQL 8.0.3 and subject to removal in a future release. mysql> SELECT JSON_MERGE('[1, 2]', '[true, false]'); +---------------------------------------+ | JSON_MERGE('[1, 2]', '[true, false]') | ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
binlog_max_flush_queue_time Command-Line Format --binlog-max-flush-queue-time=# Deprecated Yes System Variable binlog_max_flush_queue_time Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
Each time the master encryption key is rotated, all tablespace keys in the MySQL instance are re-encrypted and saved back to their respective tablespace headers. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general ...