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/upgrading-from-previous-series.html
This means that if you migrate users from a MySQL 5.6 server (any version) to one running MySQL 5.7, you must make sure to grant this privilege explicitly to any users which need to be able to create foreign keys. System Table Changes Incompatible ... Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
validate_password_check_user_name Command-Line Format --validate-password-check-user-name[={OFF|ON}] System Variable validate_password_check_user_name Scope Global Dynamic Yes Type Boolean Default Value OFF Whether validate_password compares ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...Check whether the Password column of that table is shorter than 16 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
If you wish, you can enable automatic distribution of MySQL users and privileges across NDB Cluster SQL nodes; see Section 21.6.13, “Distributed Privileges Using Shared Grant Tables”, for details. Once a MySQL user is granted privileges on an ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_default_row_format Command-Line Format --innodb-default-row-format=value System Variable innodb_default_row_format Scope Global Dynamic Yes Type Enumeration Default Value DYNAMIC Valid Values REDUNDANTCOMPACTDYNAMIC The ... System variables ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
For foreground threads (resulting from client connections), the initial values of the INSTRUMENTED and HISTORY columns in threads table rows are determined by whether the user account associated with a thread matches any row in the setup_actors ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
Administrators can prevent users from creating stored objects that specify highly privileged DEFINER accounts by not granting them the SUPER privilege. In some cases, you can prevent references to these objects by not granting unauthorized users ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. On some ...The ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased in length. Before downgrading to a previous release, change each affected ...