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/events-privileges.html
mysql.user.Event_priv is set to 'Y' for a given user only if that user has the global EVENT privilege (that is, if the privilege was bestowed using GRANT EVENT ON *.*). For a schema-level EVENT privilege, GRANT creates a row in mysql.db and sets ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
A user variable name can contain other characters if you quote it as a string or identifier (for example, @'my-var', @"my-var", or @`my-var`). (Exception: A user with access to the Performance Schema user_variables_by_thread table can see all user ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
The following sections describe how to add user-defined collations of the first two types to existing character sets. Summary of the procedure for adding a new user-defined collation: Choose a collation ID. Note If you modify an existing ...Some of ... A collation is a set of rules that defines how to compare and sort character ...Characters with equal weights compare as equal, and ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. Termination of filtering ...The ...Audit Log Functions This section describes, for each audit log function, its purpose, calling sequence, and return ...
https://dev.mysql.com/doc/refman/5.7/en/charset-column.html
CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci ) CHARACTER SET latin1 COLLATE latin1_bin; The character set and collation are specified for the column, so they are used. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8 ... Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
For example: mysql> CREATE USER 'repl'@'%.example.com' IDENTIFIED BY 'password' -> REQUIRE SSL; mysql> GRANT REPLICATION SLAVE ON *.* -> TO 'repl'@'%.example.com'; If you have an existing replication user account on the source, you can add REQUIRE ...Setting up encrypted connections for replication is similar to doing so for client/server ... To use an encrypted connection for the transfer of the binary log required during ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
To assign a filter explicitly to a particular user account or accounts, define the filter, then assign it to the relevant accounts: SELECT audit_log_filter_set_filter('log_all', '{ "filter": { "log": true } }'); SELECT ...Note By default, rule-based ...Multiple filters can be defined, and any given filter can be assigned to any number of user ... Note As of MySQL 5.7.13, for audit log filtering to work as ...
https://dev.mysql.com/doc/refman/5.7/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...In ...
https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program. For example, put these lines in the server my.cnf file: [mysqld] plugin-load-add=auth_socket.so After modifying my.cnf, restart the server ...The source code for this plugin can be examined as a relatively simple example demonstrating how to write a loadable authentication ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
However, when character_set_system differs from character_set_server or character_set_client, and you input characters manually (as database object identifiers, column values, or both), these may be displayed incorrectly in output from the client or ...The collation must be a legal collation for the default character ...