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/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/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/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/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/mysql-commands.html
For example: mysql> prompt (\u@\h) [\d]>\_ PROMPT set to '(\u@\h) [\d]>\_' (user@host) [database]> (user@host) [database]> prompt Returning to default PROMPT of mysql> mysql> . For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ...Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not ...For server side help, type 'help contents' If mysql is invoked ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. For example, the following statement creates such an account, where password is the ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
Found wrong password for user 'some_user'@'some_host'; ignoring user As a result, the account is simply ignored by the permission system. Use mysql to update the account in the user table with a new password, making sure to use the PASSWORD() ... If ...Check whether the Password column of that table is shorter than 16 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
To set the table size explicitly, set the performance_schema_users_size system variable at server startup. The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
For additional options that can be set in my.cnf for replicas, see Section 16.1.6, “Replication and Binary Logging Options and Variables”. (See Section 16.2.1, “Replication Formats”.) In addition, we recommend enabling the ... Preparing the ...To provide replication backup capability, you also need to add an --ndb-connectstring option to the replica's my.cnf file prior to starting the replication ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
--show-slave-auth-info Command-Line Format --show-slave-auth-info[={OFF|ON}] Type Boolean Default Value OFF Display replica user names and passwords in the output of SHOW SLAVE HOSTS on the source server for replicas started with the --report-user ...auto_increment_offset Command-Line Format --auto-increment-offset=# System Variable auto_increment_offset Scope Global, Session Dynamic Yes Type Integer Default Value 1 Minimum Value 1 Maximum Value 65535 This variable has a default value of ...