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/performance-schema-status-variable-summary-tables.html
The meaning of “account” in these tables is similar to its meaning in the MySQL grant tables in the mysql system database, in the sense that the term refers to a combination of user and host values. Each status variable summary table has one or ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O or SQL thread used on replica hosts. For system user, there is no host specified in the Host ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-client-commands.html
ENTER SINGLE USER MODE node_id Enters single user mode, whereby only the MySQL server identified by the node ID node_id is permitted to access the database. EXIT SINGLE USER MODE Exits single user mode, enabling all SQL nodes (that is, all running ... In addition to the central configuration file, a cluster may also be controlled through a command-line interface available through the management client ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 9.4, “User-Defined Variables”.
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 23.6, “Stored Object Access Control”. These indicate that the required privileges must be held by the user who defined or invoked the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
How do I handle MySQL users in an NDB Cluster having multiple MySQL servers? A.10.39. Users of NDB Cluster 7.3 or 7.4 should upgrade to NDB 7.5 or newer as soon as possible. There is no user-facing mechanism for influencing this selection, which is ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are ...By ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
In this case, connect to s2 and issue: SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ ...
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/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. When ...In the absence of either clause, the account is created in an unlocked ...