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/mysql-nutshell.html
MySQL now enables database administrators to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password. = 'auth_string' ...(The server writes the random password to the error log.) Installation creates no anonymous-user ...The server now requires account rows in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-top.html
This user must be able to read tables in the ndbinfo database (ndb_top uses information from ndbinfo.cpustat and related tables). For more information about MySQL user accounts and passwords, see Section 6.2, “Access Control and Account ...By ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
query-start(query, connectionid, database, user, host) query-done(status) query-start: Triggered after the query string has been received from the client. connection-start(connectionid, user, host) connection-done(status, connectionid) ...To ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
The example account, fwuser@localhost, is presumed for use by an application that accesses tables in the sakila database (available at https://dev.mysql.com/doc/index-other.html). Invoke sp_set_firewall_mode() again, this time switching the account ...To name an account for firewall operations, specify it as a single quoted string ...For example, to enable the firewall in an option file, use these lines: [mysqld] ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
System Table Changes Incompatible change: The Password column of the mysql.user system table was removed in MySQL 5.7.6. Incompatible change: MySQL 5.6.22 and later recognized the REFERENCES privilege but did not entirely enforce it; a user with at ...If it is not possible to modify an offending query (for example, if it is generated by a third-party application), set the sql_mode system variable at server startup to not enable ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and anonymous users have no access to thread information. row *************************** Id: 1 User: ... SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
As a result, it is possible to create the account and set its password without naming the plugin explicitly: CREATE USER 'sha256user'@'localhost' IDENTIFIED BY 'password'; Another consequence of setting default_authentication_plugin to ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
For InnoDB tables that have a user-defined clustered index, that index can be used even when Using index is absent from the Extra column. For DEPENDENT SUBQUERY, the subquery is re-evaluated only once for each set of different values of the ... The ...It lists the tables in the output in the order that MySQL would read them while processing the ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
If a server is running with binlog_format set to MIXED and you want it to be possible to use mysqlbinlog with the --database option, you must ensure that tables that are modified are in the database selected by USE. --defaults-extra-file=file_name ...You can also use mysqlbinlog to display the contents of relay log files written by a replica server in a replication setup because relay logs have the same format as binary ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
MySQL handles this by enabling you to distinguish users on different hosts that happen to have the same name: You can grant one set of privileges for connections by joe from office.example.com, and a different set of privileges for connections by ...