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/replication-rules-channel-based-filters.html
You cannot set up multiple replication channels from a single replica to a single source, even if you use replication filters to select different data to replicate on each channel. This section explains how to work with replication filters when ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%semi%'; +----------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. If the source database contains existing data it is necessary to copy this ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
You may either dump all databases or select databases to be dumped. Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. Anyone using MySQL on a ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-file-context.html
The /var/lib/mysql-files/ directory is intended to be used for operations such as SELECT ... The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the files could be denied. The ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
For details, see Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”, Section 7.4.3, “The General Query Log”, and Section 7.4.5, “The Slow Query Log”. MySQL Server has several logs that can help you find ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
Use of this option somewhat limits LOAD DATA and SELECT ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program Options”. The most common methods are to ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
(In particular, you can change your own password.) To see which account the server authenticated you as, invoke the CURRENT_USER() function: SELECT CURRENT_USER(); If a FOR user clause is given, the account name uses the format described in Section ... SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user ...
https://dev.mysql.com/doc/refman/8.0/en/show-character-set.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all ...