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/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/show-grants.html
SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the current user. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ...Event ...In addition, each transaction summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the connection table on which it depends, or truncation of ...row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 MIN_TIMER_READ_WRITE: 2954148000 AVG_TIMER_READ_WRITE: 3910018000 MAX_TIMER_READ_WRITE: 5486275000 ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
In this case, mysql waits for more input: mysql> SELECT USER() -> If this happens to you (you think you've entered a statement but the only response is a -> prompt), most likely mysql is waiting for the semicolon. Enter a semicolon to complete the ...(For brevity, the “rows in set” line is sometimes not shown in the remaining examples in this chapter.) Keywords may be entered in any ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
If this variable is set, its value overrides the default for $HOME/.mysql_history. USER The default user name on Windows when connecting to mysqld. For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ...Event ...In addition, each stage summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the connection table on which it depends, or truncation of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 25.1 Performance Schema Tables Table Name Description Deprecated accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
(Many Linux and other operating system distributions provide their own packages for this library.) A MySQL user account having the necessary privileges. A MySQL user name and password can be specified the corresponding options shown. If you do not ... This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
For example: mysql -u<user> -p<password> < dumpM1_nopurge.sql mysql -u<user> -p<password> < dumpM2_nopurge.sql On the replica, issue RESET MASTER to clear the GTID execution history (assuming, as explained above, that all the dump files have been ...