PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). For example: $> mysql --user=testuser --password Enter password: ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
For example: It creates the configuration file (my.ini) that is used to configure the MySQL server. It can optionally create MySQL server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. If you are setting up a new replication environment using the data from a different existing database server to create a new source, run the ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). A view can be created from many kinds of SELECT statements. To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. Without this option, mysqldump treats the first name as a database name and those following as table names. With --all-databases or --databases, mysqldump writes CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-component.html
After writing a manifest and configuration file, you should be able to access keys that were created using the keyring_oci plugin, provided that you specify the same set of configuration options to initialize the keyring component. Prior to using ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
You must therefore set up a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. The process of creating the replication user for distributed recovery can be captured in ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
Because these utilities create logical backups, the data dumped from encrypted tables is not encrypted. Does the transportable tablespaces feature work with InnoDB data-at-rest encryption? A.17.12. How do I migrate data from a cleartext InnoDB ...Is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
The reason that a long running transaction can cause the History list length to increase is that under a consistent read transaction isolation level such as REPEATABLE READ, a transaction must return the same result as when the read view for that ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. Reading master dump table data This state occurs after Opening master dump table. Rebuilding the index on master dump table This state occurs after Reading master ...