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/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. The security is ...
https://dev.mysql.com/doc/refman/8.0/en/selinux.html
MySQL SELinux policy modules, for example, define policy rules using type information. mysqld_db_t is the type associated with the MySQL data directory and its files. Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html
MySQL lets you use different sql_mode settings to tell the server the type of SQL syntax to support. For example, you might use the ANSI SQL mode to ensure MySQL correctly interprets the standard SQL concatenation operator, the double bar (||), in ... SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
If any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error occurs (ER_LONGITUDE_OUT_OF_RANGE prior to MySQL 8.0.12). If ... Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
The SRS denoted in MySQL by SRID 0 represents an infinite flat Cartesian plane with no units assigned to its axes. SRID 0 is the default SRID for spatial data in MySQL. MySQL maintains information about available spatial reference systems for ... A ...
https://dev.mysql.com/doc/refman/8.0/en/union.html
Compared to MySQL 5.7, several user-visible effects resulted from this work, which may require rewriting of certain statements: NATURAL JOIN permits an optional INNER keyword (NATURAL INNER JOIN), in compliance with standard SQL.
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...A dump file can be used in several ways: As a backup to enable data recovery in case of data ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-md5-checksum.html
After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. The correct MD5 checksum is listed on the downloads page for each MySQL product; you should compare it ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). As of MySQL 8.0.22, depending on error log configuration, the server can also write the most recent error ...Typically, the server writes diagnostics to a file on the server host or to a system log ...