PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-single-user-mode.html
Once the cluster has entered single user mode, only the designated API node is granted access to the database. Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
Run the following command: mysqlsh -u user -h localhost --classic --dba enableXProtocol Using the MySQL Client program: Open a terminal window (command prompt on Windows) and navigate to the MySQL binaries location (for example, /usr/bin/ on Linux).
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. In addition, setting max_user_connections does not enable management of individual accounts. An ...This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_default_row_format Command-Line Format --innodb-default-row-format=value System Variable innodb_default_row_format Scope Global Dynamic Yes Type Enumeration Default Value DYNAMIC Valid Values REDUNDANTCOMPACTDYNAMIC The ... System variables ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
For foreground threads (resulting from client connections), the initial values of the INSTRUMENTED and HISTORY columns in threads table rows are determined by whether the user account associated with a thread matches any row in the setup_actors ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
The user interface to MySQL accounts consists of SQL statements such as CREATE USER, GRANT, and REVOKE. MySQL handles this by enabling you to distinguish users on different hosts that happen to have the same name: You can grant one set of privileges ... MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the ...MySQL access control involves two stages when you run a client program that connects to the server: Stage 1: The server ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
These include statements that relate to account management (such as CREATE USER or GRANT), replication, and global transaction identifiers. Data Directory Initialization Overview Data Directory Initialization Procedure Server Actions During Data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
Following this practice makes the NO_AUTO_CREATE_USER SQL mode immaterial for GRANT statements, so it too is deprecated. The server now requires account rows in the mysql.user system table to have a nonempty plugin column value and disables accounts ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
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 ...Use cases for ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased in length. Before downgrading to a previous release, change each affected ...