PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/keyring-functions-general-purpose.html
(This constraint rules out the use of the keyring functions for manipulation of instance-wide keys, such as those created by InnoDB to support tablespace encryption.) To enable multiple users to perform operations on the same key, “wrapper” ...A ... MySQL Server supports a keyring service that enables internal server components and plugins to store sensitive information securely for later ...
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/mysql-cluster-security-mysql-security-procedures.html
You should also delete the anonymous user account that is installed by default. First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from running MySQL in a standard (non-Cluster) ... In ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
An error occurs if a sys schema exists but has no version view, on the assumption that its absence indicates a user-created schema: A sys schema exists with no sys.version view. If you have a user created sys schema, this must be renamed for the ...
https://dev.mysql.com/doc/refman/5.7/en/rename-user.html
To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system database. For example: RENAME USER 'jeffrey'@'localhost' TO 'jeff'@'127.0.0.1'; The host name part of the account name, if omitted, ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
To require use of encrypted connections by a MySQL account, use CREATE USER to create the account with a REQUIRE SSL clause, or use ALTER USER for an existing account to add a REQUIRE SSL clause. For additional details about which command options ...
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/validate-password-options-variables.html
validate_password_check_user_name Command-Line Format --validate-password-check-user-name[={OFF|ON}] System Variable validate_password_check_user_name Scope Global Dynamic Yes Type Boolean Default Value OFF Whether validate_password compares ...This ... 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/group-replication-user-credentials.html
This process can be captured in the binary log and then you can rely on distributed recovery to replicate the statements used to create the user. Alternatively, you can disable binary logging using SET SQL_LOG_BIN=0; and then create the user ...