Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. Error symbols are recognized only in comparisons with the err_code field and user-defined fields. Using perror, determine the error symbols: $> perror ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has one or more grouping columns to indicate how the table aggregates status values: status_by_account has USER, HOST, and VARIABLE_NAME columns to summarize status variables by account. status_by_user has USER and ... The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
If set to 0 (the default), users are not permitted to create or alter stored functions unless they have the SUPER privilege in addition to the CREATE ROUTINE or ALTER ROUTINE privilege. The server creates binary log files in sequence by adding a ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-copy-mysql-configuration.html
They are not removable by the X button, and will remain as user variables in the new custom configuration you are creating. User-defined variables are those that have ever been set in a configuration dialog when the configuration or its base ...You ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-iam-policy.html
This can be the MySQL Administrator user specified when creating the DB System (see Creating a DB System) or a MySQL user account created on the DB System using CREATE USER . If you are not the MySQL Administrator and you do not have a MySQL user ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
Note Like the mysql.func system table, the Performance Schema user_defined_functions table lists loadable functions installed using CREATE FUNCTION. Previously, these tables were created in individual tablespace files in the mysql database directory. Grant System Tables These system tables contain grant information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. The ...In the absence of either clause, the account is created in an unlocked ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-2-0.html
For example, with partial_revokes set to ON, GRANT SELECT ON db_.* TO user1 allows user1 to select from any table in a database named db_, but does not allow user1 to select from tables in databases db1, db2, dbx, dby, and so on. This automatic ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
This applies to the ALTER USER, CREATE USER, and SET PASSWORD statements. For CREATE USER statements, validate_password requires that a password be given, and that it satisfies the password policy. Note For statements that assign or modify account ...In addition, validate_password supports the capability of rejecting passwords that match the user name part of the effective user account for the current session, either forward or in ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...