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/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. By convention, routines that call sys_get_config() first check ...If ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
If usera connects again from host1.example.com, the server applies the limits for that connection together with the existing connection from that host. To modify the limits for an existing account, use ALTER USER. To modify limits for an existing ...
https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html
To use a localized systemd configuration file, create the /etc/systemd/system/mysqld.service.d directory if it does not exist. Specify the values in the /etc/sysconfig/mysql file (create the file if it does not exist). As of MySQL 5.7.20, to ...If ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
version_tokens_delete() deletes the tokens named in its argument, if they exist. (It is not an error to delete nonexisting tokens.) To clear the token list entirely without knowing which tokens are in the list, pass NULL or a string containing no ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
Many theoretically updatable views can be updated now, but limitations still exist. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a ...
https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. Use mysqlshow to see what databases exist: C:\> bin\mysqlshow +--------------------+ | Databases | ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was performed. You may either overwrite your existing MySQL ...Before proceeding, review Section 2.10, “Upgrading MySQL” for additional information on upgrading MySQL that is not specific to ...
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html
When used with ALTER USER, these clauses specify the new locking state for an existing account. For upgrades from MySQL versions older than 5.7.6, perform the MySQL upgrade procedure to ensure that this column exists. MySQL supports locking and ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts).
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root[root] @ localhost ... The MySQL ...