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/time-zone-support.html
For example: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql The mysql command shown here assumes that you connect to the server using an account such as root that has privileges for modifying tables in the mysql system database.
https://dev.mysql.com/doc/refman/5.7/en/update.html
You need the UPDATE privilege only for columns referenced in an UPDATE that are actually updated. You need only the SELECT privilege for any columns that are read but not modified. UPDATE is a DML statement that modifies rows in a table.
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
mysql_upgrade also upgrades the mysql system database so that you can take advantage of new privileges or capabilities. mysql_upgrade also upgrades the mysql system database so that you can take advantage of new privileges or capabilities. This ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. SQL statements can be executed using the mysql command-line ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
The SUPER privilege is required to call any of the Version Token functions, so token list modification is expected to be done by a management or administrative application that has that privilege. Before using Version Tokens, install it according ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a database. These ...
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, defines actions applicable to a MySQL server instance. The statement supports these actions: ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master ...
https://dev.mysql.com/doc/refman/5.7/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or tables. For MyISAM tables, this statement is equivalent to using myisamchk --analyze. ANALYZE TABLE is supported for partitioned tables, and you ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-disabling.html
The audit_log_disable variable, introduced in MySQL 5.7.37, permits disabling audit logging for all connecting and connected sessions. The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at ...