Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
For example: mysql> CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 4326 ...; ERROR 3716 (SR005): Can't modify SRID 4326. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] ...srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and stores it in the data ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. To update the tables to the expected structure, perform the MySQL upgrade procedure. Another option for creating ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL Components”. By default, log_error_services has the value shown here: mysql> SELECT @@GLOBAL.log_error_services; ...The error log subsystem ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. The MySQL client library takes errors received from the server and makes them available to ...These indicate issues of interest to database administrators or that require DBA ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-use-cases.html
To summarize, MySQL Group Replication guarantees that the database service is continuously available. To summarize, MySQL Group Replication provides a highly available, highly elastic, dependable MySQL service. Tip To deploy multiple instances of ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The import server uses /tmp/mysql-files as the directory named by its secure_file_priv ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial product. Any configuration file that stores a password should have a restrictive mode and be accessible only to the account used to run the ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. Use the ...The ...