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/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the proc table exists. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients ...
https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html
Note When using the MySQL Installer to install MySQL Server, it creates the my.ini in the default location, and the user executing MySQL Installer is granted full permissions to this new my.ini file. If you need to specify startup options when you ...
https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html
If necessary, initialize the data directory and create the MySQL grant tables. GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. Windows distributions ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
Note The initial root account in the MySQL grant tables has no password. This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
As Administrator, run mysql_upgrade to check your tables, attempt to repair them if necessary, and update your grant tables if they have changed so that you can take advantage of any new capabilities. There are two approaches for upgrading MySQL on ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
(See Section 13.1.12, “CREATE EVENT Statement”.) Any user can alter an event defined on a database for which that user has the EVENT privilege. and db_name.event_name notation, as shown here: ALTER EVENT olddb.myevent RENAME TO newdb.myevent; To ... ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the characteristics of an existing event without the need to drop and recreate ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The tables can be accessed only by users who have privileges for that database. Unless those objects are installed, the audit_log plugin operates in legacy mode. Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
A client that has privileges sufficient to set restricted session system variables (see Section 5.1.8.1, “System Variable Privileges”) can disable binary logging of its own statements by using a SET sql_log_bin=OFF statement. The binary log ...