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/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/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/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. For information about the physical representation of a table, see ...| ...
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-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/connection-access.html
Account locking can be set or changed with the CREATE USER or ALTER USER statement. For the rules governing permissible Host and User values, see Section 6.2.4, “Specifying Account Names”. Rather, the password supplied by a user who is ...The ...
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-temporary-table.html
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them. Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute ... You can use the TEMPORARY keyword when creating a ...A TEMPORARY table is visible only within the current ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...