Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Granting the SELECT privilege for the error_log table thus gives clients and applications access to error log contents using SQL queries, enabling DBAs to provide access to the log without the need to permit direct file system access on the server ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-filtering.html
| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ... | wait/synch/rwlock/sql/LOCK_grant | YES | YES | | wait/synch/rwlock/sql/LOGGER::LOCK_logger | YES | ... The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | +---------------------------------------------------+---------+-------+ ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ... | wait/synch/rwlock/sql/LOCK_grant | YES | YES | | wait/synch/rwlock/sql/LOGGER::LOCK_logger | YES | ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
The client-side authentication_ldap_sasl_client plugin obtains a service ticket using the ticket-granting ticket (TGT) from Kerberos, but does not use LDAP services directly. The file name should be given as an absolute path name. If this variable ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysqladmin A client that performs administrative operations, such as creating or dropping databases, reloading the grant tables, flushing tables to disk, and reopening log files. Later sections provide a more detailed description of each one, with ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
Any privileges granted specifically for a renamed table or view are not migrated to the new name. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
You can use the asynchronous connection failover mechanism to establish an asynchronous (source-to-replica) replication connection to a new source automatically, after the existing connection from a replica to its source fails. The asynchronous ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
This means that the replica can accept only that part of the database to which a given user has been granted access (as long as any updates to this part of the database use the row-based replication format). If a statement produces the same error ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...