PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
You must have SELECT, DELETE, and UPDATE privileges on the MyISAM tables that you map to a MERGE table. However, if the user's privileges on t are subsequently revoked, the user can continue to access t by doing so through m. The MERGE storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
It is worth taking into account that Cluster nodes do not make use of the MySQL privilege system when accessing one another. See Section 21.6.18.2, “NDB Cluster and MySQL Privileges”, for more information. Note The information in this section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ...If mysql_upgrade finds that a table has a possible incompatibility, it performs a table check and, if problems are found, attempts a table ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... Table nt contains no foreign key references, and no other table has any foreign keys ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
Rows can be inserted into or deleted from setup_objects by users with the INSERT or DELETE privilege on the table. For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
The user has a column-level privilege for any of the involved tables. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-thread-states.html
checking privileges on cached query The server is checking whether the user has privileges to access a cached query result. These thread states are associated with the query cache (see Section 8.10.3, “The MySQL Query Cache”). checking query ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
Note Certain steps within the setup process require the SUPER privilege. If you do not have this privilege, it might not be possible to enable replication. This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
The ability to configure the replication mode online means that the gtid_mode and enforce_gtid_consistency variables are now both dynamic and can be set from a top-level statement by an account that has privileges sufficient to set global system ...
https://dev.mysql.com/doc/refman/5.7/en/reserved-accounts.html
Strictly speaking, this account name is not reserved, in the sense that some installations rename the root account to something else to avoid exposing a highly privileged account with a well-known name. One part of the MySQL installation process is ...