PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. As of MySQL 8.0.16, users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. DROP ROLE removes one or more roles ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
When you must move information over a network in a secure fashion, an unencrypted connection is unacceptable. By default, MySQL programs attempt to connect using encryption if the server supports encrypted connections, falling back to an unencrypted ... With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rotation.html
If the location of the error log file is not writable by the server, the log-flushing operation fails to create a new log file. For example, assuming a log file name of host_name.err, use the following commands to rename the file and create a new ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometry.html
It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry subclasses. To ensure SRID 0 behavior, create geometry values using SRID 0.
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
See Section 14.16.3, “Functions That Create Geometry Values from WKT Values”, and Section 14.16.4, “Functions That Create Geometry Values from WKB Values”. MySQL supports the functions listed in this section for converting geometry values ...
https://dev.mysql.com/doc/refman/8.0/en/gis-geometry-class-hierarchy.html
The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) ...All classes have properties, and instantiable classes may also have assertions (rules that define valid class ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-single-primary-mode.html
This section explains how to create a replication group with three MySQL Server instances, each running on a different host machine. Figure 20.7 Group Architecture This tutorial explains how to get and deploy MySQL Server with the Group Replication ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
If a group member does not receive any messages from a particular fellow member for 5 seconds, when this detection period ends, it creates a suspicion of the fellow member. By default, the following behaviors happen if a member is suspected of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. Section 20.2, “Getting Started” explains how to configure multiple MySQL Server instances to create a group. This chapter explains ...
https://dev.mysql.com/doc/refman/8.0/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...