PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-account.html
Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. Example mysql> SELECT ...The value should match the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-account-connect-attrs-table.html
The session_account_connect_attrs table contains connection attributes only for the current session, and other sessions associated with the session account. The session_account_connect_attrs table has these columns: PROCESSLIST_ID The connection ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the DEFINER clause is present, the user value should be a MySQL account specified as 'user_name'@'host_name', CURRENT_USER, or CURRENT_USER(). If the DEFINER clause is omitted, the default definer is the user who executes the CREATE VIEW ...If ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
row *************************** CREATE USER for root@localhost: CREATE USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK The output ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
If the directory specified does not exist, NDB attempts to create it; the system user account under which the data node process is running must have the appropriate permissions to do so. Considerations for InnoDB Considerations for NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... If the DEFINER ...CREATE EVENT requires the EVENT privilege for the schema in which the event is to be ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
MySQL takes the DEFINER user into account when checking trigger privileges as follows: At CREATE TRIGGER time, the user who issues the statement must have the TRIGGER privilege. CREATE [DEFINER = user] TRIGGER trigger_name trigger_time ...CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
Warning This option creates a MySQL root user with an empty password, which is insecure. (Before MySQL 5.0.3, account resource limits were counted separately for each host from which a user connected rather than per account row in the user table.) ...--bootstrap Command-Line Format --bootstrap Deprecated Yes This option is used by the mysql_install_db program to create the MySQL privilege tables without having to start a full MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...