PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
mysql> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ FOR CHANNEL 'group_replication_recovery'; Distributed recovery is the first step taken by a server that joins the group and does not have the same set of transactions as ...Therefore you need to set up a replication user with the correct permissions so that Group Replication can establish direct member-to-member recovery replication ... Group ...The ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
For information about user auditing within events, see Section 6.2.18, “SQL-Based Account Activity Auditing”. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. --user=user_name, -u user_name Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
keyring-migration-user: User name for connecting to running server for key migration. binlog_group_commit_sync_delay: Sets number of microseconds to wait before synchronizing transactions to disk. binlog_group_commit_sync_no_delay_count: Sets ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-latency.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total_latency The total wait time of timed statements for the user. The ...
https://dev.mysql.com/doc/refman/5.7/en/rename-user.html
To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system database. For example: RENAME USER 'jeffrey'@'localhost' TO 'jeff'@'127.0.0.1'; The host name part of the account name, if omitted, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
In such cases, the server returns ER_HOST_NOT_PRIVILEGED and does not even ask for a user name or password. For example, the database does not exist or the user has no privileges to access it. MySQL does not perform matching of Host column values in ...COUNT_HOST_ACL_ERRORS The number of errors that occur because no users are permitted to connect from the client ... The MySQL server maintains an in-memory host ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
Finally, before trying to start the MySQL service, make sure the user variables %TEMP% and %TMP% (and also %TMPDIR%, if it has ever been set) for the operating system user who is to run the service are pointing to a folder to which the user has ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/load-data.html
With user variables, the SET clause enables you to perform preprocessing transformations on their values before assigning the result to columns. User variables in the SET clause can be used in several ways. User variables cannot be used when loading ...By default, the server interprets the file contents using the character set indicated by the character_set_database system ...