Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O or SQL thread used on replica hosts. For system user, there is no host specified in the Host ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
As an efficiency measure to minimize the number of direct reads from the sys_config table, sys schema functions that use a value from this table check for a user-defined variable with a corresponding name, which is the user-defined variable having ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-cloud-options.html
The user credentials are authenticated by the Swift TempAuth identity system when the --cloud-tempauth-url option is used, by the OpenStack Keystone identity service when the --cloud-identity-url option is used, and by HTTP Basic Authentication when ... These options are for using cloud storage for single-file ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
Grant System Tables These system tables contain grant information about user accounts and the privileges held by them. global_grants: Assignments of dynamic global privileges to users; see Static Versus Dynamic Privileges. Data Dictionary Tables ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-change-user.html
bool mysql_change_user(MYSQL *mysql, const char *user, const char *password, const char *db) Description Changes the user and causes the database specified by db to become the default (current) database on the connection specified by mysql. In ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
If you are using the Rewriter plugin, you should grant this user the SKIP_QUERY_REWRITE privilege. To execute the internal-use BINLOG statements used by mysqlbinlog, the user requires the BINLOG_ADMIN privilege (or the deprecated SUPER privilege), ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-multi.html
For example, you might set up a common multi_admin account by executing the following commands for each server: $> mysql -u root -S /tmp/mysql.sock -p Enter password: mysql> CREATE USER 'multi_admin'@'localhost' IDENTIFIED BY 'multipass'; mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/network-namespace-support.html
A connection may produce a result like this: $> mysql --user=admin --host=203.0.113.10 --protocol=tcp mysql> SELECT USER(); +--------------------+ | USER() | +--------------------+ | admin@198.51.100.2 | +--------------------+ In this case, the ...
https://dev.mysql.com/doc/x-devapi-userguide/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...