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/mysqldump.html
--user=user_name, -u user_name Command-Line Format --user=user_name Type String The user name of the MySQL account to use for connecting to the server. Because the server creates *.txt files in the directory that you specify, the directory must be ...To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html
These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). ST_GeomFromText() accepts a WKT value of any geometry type as its first argument. Other functions provide ...
https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html
The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. When entering single user mode, connections to all other API nodes ...You can also check the status column of the ndbinfo.nodes table (see Section 21.6.15.28, “The ndbinfo nodes Table”, for more ...
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/validate-password-options-variables.html
validate_password_check_user_name Command-Line Format --validate-password-check-user-name[={OFF|ON}] Introduced 5.7.15 System Variable validate_password_check_user_name Scope Global Dynamic Yes Type Boolean Default Value OFF Whether ...This variable ... This section describes the options, system variables, and status variables that validate_password provides to enable its operation to be configured and ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
The option does not affect authentication (4.1 and later clients can still use accounts that have long password hashes), but it does prevent creation of a long password hash in the user table as the result of a password-changing operation. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
Experienced users can adjust the isolation level, trading off less protection in favor of increased performance and concurrency, when they can be sure that the transactions really do not interfere with each other. Closing an account at an online ...
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/upgrading-from-previous-series.html
Incompatible change: As of MySQL 5.7.2, the server requires account rows in the mysql.user system table to have a nonempty plugin column value and disables accounts with an empty value. Incompatible change: MySQL 5.6.22 and later recognized the ...