Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/en/mysql-cluster-programs-ndb-mgmd.html
All options that can be used with ndb_mgmd are shown in the following table. By default, the management server looks for a file named config.ini in the same directory as the ndb_mgmd executable; otherwise the file name and location must be specified ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
As an alternative to proxy users, DBAs may find that roles provide a suitable way to map users onto specific sets of named privileges. Use the CREATE USER statement to associate an account with an authentication plugin, or ALTER USER to change its ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of service. When running MySQL, follow ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
Note Rather than using SET PASSWORD to assign passwords, ALTER USER is the preferred statement for account alterations, including assigning passwords. For example: ALTER USER user IDENTIFIED BY 'auth_string'; Note Clauses for random password ... SET ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-results.html
The import icon opens the Table Data Import dialog from which you can select a data file and other options, such as the destination table. Export or Import data directly from or into the result set. The export and import operations shown in this ...