Search Results
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
If the server is started with the --skip-grant-tables option, functions registered in the mysql.func table are not loaded and are unavailable. Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
Also note the requirements described in Grant MySQL Privileges to Backup Administrator and Using MySQL Enterprise Backup with Group Replication. MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
In this case, the server uses only IP addresses and not host names to match connecting hosts to rows in the MySQL grant tables. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and ...
https://dev.mysql.com/doc/refman/8.4/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
Notes To see information about a routine, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-user-attributes-table.html
The access control system has not been initialized (for example, the server was started with the --skip-grant-tables option). The USER_ATTRIBUTES table provides information about user comments and user attributes. The USER_ATTRIBUTES table has ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
This occurs even if the server is started with the --skip-grant-tables option. [SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} ...