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/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/charset-applications.html
The examples shown here assume use of the utf8 character set and utf8_general_ci collation in particular contexts as an alternative to the defaults of latin1 and latin1_swedish_ci. To create a database such that its tables use a given default ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
Section 23.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the event table ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Alternatively, you can use ON (or 1) or OFF (or 0) in place of the DISABLED value when starting the server. Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server and whether connections are encrypted. Command Options for Connection Establishment Command Options for ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. Note Alternative means for performing the process described in this section: On Windows, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
Proceed to checking the table-level replication options, if there are any. For a description of how these options are checked, see Section 16.2.5.2, “Evaluation of Table-Level Replication Options”. The statement is not executed until all ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. This value may be updated by ALTER EVENT to ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
Whereas a trigger is a database object whose statements are executed in response to a specific type of event that occurs on a given table, a (scheduled) event is an object whose statements are executed in response to the passage of a specified time ... MySQL Events are tasks that run according to a ...