PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/5.7/en/replication-features-user-names.html
The maximum length of MySQL user names was increased from 16 characters to 32 characters in MySQL 5.7.8. Replication of user names longer than 16 characters to a replica that supports only shorter user names fails. However, this should occur only ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
If set to 0 (the default), users are not permitted to create or alter stored functions unless they have the SUPER privilege in addition to the CREATE ROUTINE or ALTER ROUTINE privilege. When enabled, the variable has the following effects: Binary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: memory_summary_by_account_by_event_name has USER, HOST, and EVENT_NAME columns. Each row summarizes events for a given account (user and host combination) and event name. In addition, each memory 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/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
It also influences password hashing performed by CREATE USER and GRANT statements that specify a password using an IDENTIFIED BY clause. Storing the string also results in slower comparisons because of the larger values and the need to take ...If ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...Passwords ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
For example, the following statement creates such an account, where password is the desired account password: CREATE USER 'sha2user'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password'; caching_sha2_password supports connections over ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_stages_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST columns. Each row summarizes events for a given account (user and host combination) and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_transactions_summary_by_account_by_event_name has USER, HOST, and EVENT_NAME columns. Each row summarizes events for a given account (user and host combination) ...Each row summarizes events for a given user and event ... The Performance Schema maintains tables for collecting current and recent transaction ...