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/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/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-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/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/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 ...