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/rewriter-query-rewrite-plugin.html
The Rewriter plugin uses a database named query_rewrite containing a table named rewrite_rules. The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
Make sure that the only Unix user account with read or write privileges in the database directories is the account that is used for running mysqld. With this privilege, you can read any file into a database table. When you connect to a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of service. When running MySQL, follow ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
You can refer to a table within the default database as tbl_name, or as db_name.tbl_name to specify a database explicitly. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
In addition to storing metadata about database objects in the data dictionary, MySQL stores it in serialized form. Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. Client users can obtain the RSA public key two ways: The database administrator can provide ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
MySQL maps certain data types used by other SQL database vendors to MySQL types. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. Removal of the package does not delete the existing database information, only the server, binaries and ... You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the ...
https://dev.mysql.com/doc/refman/8.0/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The guidelines cover SQL operations that read and write data, the ...The ...