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/what-is-mysql.html
A relational database stores data in separate tables rather than putting all the data in one big storeroom. The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. You set up ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
After this, all tables created in the database mydb are created in D:\data\mydb. Alternatively, on any version of Windows supported by MySQL, you can create a symbolic link to a MySQL database by creating a .sym file in the data directory that ...
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, ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/validate-password-options-variables.html
If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. When validate_password.check_user_name is enabled, it has these effects: Checking occurs in all contexts for which ... This ...