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/system-schema.html
Grant System Tables These system tables contain grant information about user accounts and the privileges held by them: user: User accounts, global privileges, and other nonprivilege columns. For more information about the structure, contents, and ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
(For a discussion of concepts involved in proxying, see Section 6.2.14, “Proxy Users”.) An account that authenticates using mysql_no_login may be used as a proxied user for proxy accounts: -- create proxied account CREATE USER ... The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. The name of the performance_schema database is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now sets the access control granted to clients on the named pipe to the minimum necessary for successful communication on Windows. Following this practice makes the NO_AUTO_CREATE_USER SQL mode immaterial for GRANT statements, so it too is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-event-reports.html
In this section, we discuss the types of event logs provided by NDB Cluster, and the types of events that are logged. NDB Cluster provides two types of event log: The cluster log, which includes events generated by all cluster nodes. The cluster ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
FLUSH PRIVILEGES Re-reads the privileges from the grant tables in the mysql system database. Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
This means that if you migrate users from a MySQL 5.6 server (any version) to one running MySQL 5.7, you must make sure to grant this privilege explicitly to any users which need to be able to create foreign keys. Before upgrading to MySQL 5.7, ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
Caution Do not use this command used if the server was started with the --skip-grant-tables option. This is true even if you precede the password command with flush-privileges on the same command line to re-enable the grant tables because the flush ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
By default, the replication I/O thread does not write binary log events to the relay log if they have the replica's server ID (this optimization helps save disk usage). For example, a GRANT statement, which updates the mysql.user system table but ...