Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/mysql-monitor/8.0/en/mem-users-created-first-login.html
The Manager user: This user is the administrator of MySQL Enterprise Service Manager. The Agent user: MySQL Enterprise Monitor Agent broadcasts the status of the assets it is monitoring and requires access to MySQL Enterprise Service Manager. For a ...These credentials must also be provided for the agent installation ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
To set this up, create a MySQL account named sql_admin that uses the Windows plugin for authentication: CREATE USER sql_admin IDENTIFIED WITH authentication_windows AS 'Rafal, Tasha, Administrators, "Power Users"'; The plugin name is ...Using ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-created-users.html
The Repository user: This user is the only user in the user table in the mysql database in the bundled MySQL server. The repository user can log in from localhost using the password specified during installation and has all privileges on all ...To ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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 [IF NOT EXISTS] trigger_name ...CREATE ...A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... If ...CREATE EVENT requires the EVENT privilege for the schema in which the event is to be ...