Search Results
https://dev.mysql.com/doc/refman/8.4/en/automatic-start.html
The following table shows which option groups the server and startup scripts read from option files. Table 2.16 MySQL Startup Scripts and Supported Server Option Groups Script Option Groups mysqld [mysqld], [server], [mysqld-major_version] ... This ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should assign passwords to the MySQL root account in the grant tables. On Windows, you can run the server as a Windows service using a normal user account. On ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
The example also shows how to use the INFORMATION_SCHEMA COLLATIONS table to determine the pad attribute for collations. This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary ...
https://dev.mysql.com/doc/refman/8.4/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated; you should expect them to be ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/8.4/en/cleartext-pluggable-authentication.html
Table 8.17 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-concurrent-ddl.html
DDL operations that are not permitted during a cloning operation regardless of the clone_block_ddl setting include: ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE; ALTER INSTANCE DISABLE INNODB REDO_LOG; . In MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
User-created data (schemas, tables, tablespaces) and binary logs on the recipient are removed before data is cloned to the recipient data directory. [Warning] [MY-013453] [InnoDB] Clone removing all user data for provisioning: Finished If a failure ... This section describes failure handing at different stages of a cloning ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-installation.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”). This section describes how to install and configure the clone plugin. For ...