PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. When ...In the absence of either clause, the account is created in an unlocked ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-socket-layer-support-ssl.html
This variable has the following possible values: Table 20.1 group_replication_ssl_mode configuration values Value Description DISABLED Establish an unencrypted connection (the default). REQUIRED Establish a secure connection if the server supports ... Secure sockets can be used for group communication connections between members of a ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
From the Installation Type page you can either click Install to execute the installation wizard using all defaults, click Customize to alter which components to install (MySQL server, MySQL Test, Preference Pane, Launchd Support -- all but MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. Stored routines require the events data dictionary table in the mysql system database. The MySQL Event Scheduler manages the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-component.html
(Alternatively, you can reuse an existing vault that is in a parent compartment of the MySQL compartment.) Compartment users can see and use only the keys in their respective compartments. To obtain the key fingerprint while creating the API keys, ... Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you should update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-configuration.html
Important Once you have started a mysqld process with the ndbcluster and ndb-connectstring parameters in the [mysqld] and [mysql_cluster] sections of the my.cnf file as shown previously, you cannot execute any CREATE TABLE or ALTER TABLE statements ... In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-setup.html
One alternative is to use a predetermined setup type that matches your setup requirements. An instance of MySQL server using an alternative installation path, data path, or both. For instructions on how to adjust the paths, see Section 2.3.3.2, ...