Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Strong MySQL Privilege User Exclusion Regex: This advisor enables you to define a regular expression describing the users allowed to have global privileges on the mysql.user table (CREATE_USER, FILE, GRANT, PROCESS, LOCK_TABLES, SHUTDOWN, SUPER or ... This section describes the following Security advisors: MySQL Enterprise Audit Plugin MySQL Enterprise Firewall MySQL User Account MySQL Enterprise Audit Plugin Note For more information on the MySQL Enterprise Audit Plugin, see MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
Suppose that the user jon@ghidora has been granted the EVENT and INSERT privileges on the myschema schema. mysql.user.Event_priv is set to 'Y' for a given user only if that user has the global EVENT privilege (that is, if the privilege was bestowed ...Suppose also that this user has the SELECT privilege for myschema, but no other privileges for this ... To enable or disable the ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
mysql> SELECT CHARSET('abc'); -> 'utf8mb3' mysql> SELECT CHARSET(CONVERT('abc' USING latin1)); -> 'latin1' mysql> SELECT CHARSET(USER()); -> 'utf8mb3' COERCIBILITY(str) Returns the collation coercibility value of the string argument. mysql> SELECT ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
You may discuss these, ask questions about them, and obtain help from other users with them in the MySQL XML User Forum. XPath expressions used with these functions support user variables and local stored program variables. User variables are weakly ... Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from all grant tables. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql ...Roles named in the mandatory_roles system variable value cannot be ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. A user ...This ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
An event in the connection class indicates when a connection-related activity occurs during a session, such as a user connecting to or disconnecting from the server. Important It is theoretically possible for a user with sufficient permissions to ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
Do not grant the PROCESS or SUPER privilege to nonadministrative users. It is common for client/server applications that the user can specify any user name to the client program. For example, anyone can use the mysql program to connect as any other ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
You grant the REPLICATION_APPLIER privilege to enable a user account to appear as the PRIVILEGE_CHECKS_USER for a replication applier thread, and to execute the internal-use BINLOG statements used by mysqlbinlog. After setting up the user account, ...You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
Account names appear in SQL statements such as CREATE USER, GRANT, and SET PASSWORD and follow these rules: Account name syntax is 'user_name'@'host_name'. MySQL stores account names in grant tables in the mysql system database using separate ...