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/information-schema-introduction.html
For example, Oracle Database users are familiar with querying tables in the Oracle data dictionary. INFORMATION_SCHEMA and Privileges For most INFORMATION_SCHEMA tables, each MySQL user has the right to access them, but can see only the rows in the ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
Undo logs that reside in the temporary tablespace are used for transactions that modify data in user-defined temporary tables. An undo log is a collection of undo log records associated with a single read-write transaction. An undo log record ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-security.html
MySQL Enterprise Edition provides plugins that implement security features using external services: MySQL Enterprise Edition includes an authentication plugin that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) to ...PAM ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. The function is intended to be invoked by the stored procedure, not directly by ...Note The rules table is loaded into the plugin by the flush_rewrite_rules stored ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
--keyring-migration-user=user_name Command-Line Format --keyring-migration-user=user_name Introduced 5.7.21 Type String The user name of the MySQL account used for connecting to the running server that is currently using one of the key migration ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. Access to this table should never be granted to any nonadministrative accounts. A user who has access to modify ... Database administrators should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
It is possible to place these elsewhere by specifying either an absolute or relative path as part of the filename when creating the undo log or data file. Statements that create these files are shown later in this section. Create a tablespace; ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
DEFINER The account named in the DEFINER clause (often the user who created the event), in 'user_name'@'host_name' format. EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to ... The EVENTS table provides information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
As an administrator, connect to the server and create an account for a local user who connects from the ::1 local IPv6 host address: mysql> CREATE USER 'ipv6user'@'::1' IDENTIFIED BY 'ipv6pass'; For the permitted syntax of IPv6 addresses in account ...Invoke the mysql client to connect to the server using the new account: $> mysql -h ::1 -u ipv6user -pipv6pass Try some simple statements that show connection information: mysql> STATUS ...mysql> SELECT ...