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/partial-revokes.html
Prior to MySQL 8.0.16, it is not possible to grant privileges that apply globally except for certain schemas. As of MySQL 8.0.16, that is possible if the partial_revokes system variable is enabled. Specifically, for users who have privileges at the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
For example, the database does not exist or the user has no privileges to access it. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups.
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
You want to have an administrator account that enables an administrator to perform only operations that are directly relevant to the replication channel and the databases it replicates, rather than having wide privileges on the server instance. By ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
For a current list of supported platforms, see: https://www.mysql.com/support/supportedplatforms/database.html Understand MySQL Server Changes Each major version comes with new features, changes in behavior, deprecations, and removals. Run Upgrade ... MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html
The firewall database can be the mysql system database or a custom schema (see Installing MySQL Enterprise Firewall). Firewall Group Profile Tables Firewall Account Profile Tables Firewall Group Profile Tables As of MySQL 8.0.23, MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. ndb_import ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
This can be a more convenient means of repairing tables because you can use the --databases or --all-databases option to repair all tables in specific databases or all databases, respectively: mysqlcheck --repair --databases db_name ... This ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
Suppose that a management application communicates with a set of servers that are queried by clients to access employee and product databases (named emp and prod, respectively). All servers are permitted to process data retrieval statements, but ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
(Bug #28086) When one of the tables involved is a log table in the mysql database. The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset ...