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/creating-accounts.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and ...
https://dev.mysql.com/doc/refman/8.0/en/creating-rsa-files-using-openssl.html
Note There are easier alternatives to generating the files required for RSA than the procedure described here: Let the server autogenerate them or use the mysql_ssl_rsa_setup program (deprecated as of MySQL 8.0.34). This section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
See also the notes about spatial indexes under Section 13.4.10, “Creating Spatial Indexes”. MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
Note There are easier alternatives to generating the files required for SSL than the procedure described here: Let the server autogenerate them or use the mysql_ssl_rsa_setup program (deprecated as of 8.0.34). This section describes how to use the ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based metadata storage included expensive ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Note Enabling innodb_read_only also has important implications for non-data dictionary tables in the mysql system database. Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory.html
Note INFORMATION_SCHEMA is a standard database, but its implementation uses no corresponding database directory. Information managed by the MySQL server is stored under a directory known as the data directory. The following list briefly describes ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components-vs-plugin.html
Note Only the data-masking components or the plugin should be enabled at a time. Prior to 8.0.33, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
Note The examples here supply function arguments using the random value generation functions that return the appropriate type of value. Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions ...