Search Results
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions here. To use a keyring plugin instead, begin with Section 8.4.4.3, “Keyring Plugin Installation”. If you ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-plugin-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'keyring%'; +--------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------+---------------+ | keyring_okv | ACTIVE | ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
In most cases, it might take some time for the thread to die because the kill flag is checked only at specific intervals: During SELECT operations, for ORDER BY and GROUP BY loops, the flag is checked after reading a block of rows. KILL [CONNECTION ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community Edition of MySQL: From the MySQL software repositories: The MySQL Yum ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
FLUSH LOGS supports optional modifiers to enable selective flushing of individual logs (for example, FLUSH BINARY LOGS). As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
To enable the launchd service, you can either: Open macOS system preferences and select the MySQL preference panel, and then execute Start MySQL Server. macOS uses launch daemons to automatically start, stop, and manage processes and applications ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-prefpane.html
The "Preference Pane" option is listed there and enabled by default; make sure it is not deselected. The other options, such as MySQL Server, can be selected or deselected. The MySQL Installation Package includes a MySQL preference pane that ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-optimization.html
This makes your data much more localized and may speed up range-based SELECT and ORDER BY operations that use this index. To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-check-options.html
This is the default operation if you specify no option that selects an operation type explicitly. myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors.