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/server-options.html
For example, you can use --admin-ssl=OFF to start the administrative interface with encrypted connections disabled, then reconfigure TLS and execute ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin to enable encrypted connections at runtime. To ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
If two values originally come from the MySQL DATETIME and TIMESTAMP types, respectively, they are equal if they represent the same point in time. MySQL also supports the JSON Merge Patch format defined in RFC 7396, using the JSON_MERGE_PATCH() ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted connections. To use TLSv1.3, both the MySQL server and the client application must be compiled using OpenSSL 1.1.1 or ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
Assign values using the following syntax: LD_PRELOAD=/path/to/malloc/library TZ=time_zone_setting After modifying /etc/sysconfig/mysql, restart the server to make the changes effective: systemctl restart mysqld # RPM platforms systemctl restart ...
https://dev.mysql.com/doc/refman/8.0/en/MySQLInstallerConsole.html
On success, the catalog is applied the next time either MySQLInstaller or MySQLInstallerConsole.exe is executed. MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL Installer. This reference includes: MySQL ...To ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
(The menu item mentioned previously sets the font and character set as just described.) To avoid those steps each time you run mysql, you can create a shortcut that invokes mysql.exe. This section provides information about techniques for more ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 This function is safe to use with BIGINT values. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns the arc sine of X, ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
MySQL implements regular expression support using International Components for Unicode (ICU), which provides full Unicode support and is multibyte safe. (Prior to MySQL 8.0.4, MySQL used Henry Spencer's implementation of regular expressions, which ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
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/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...