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/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. To do this, you must have a mysqld that has been compiled with debugging support. If the version number ends with -debug, it is ...
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/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/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/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/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/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 ...
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/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 ...