Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-role.html
(These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. By default, an error ... CREATE ROLE [IF NOT EXISTS] role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
Installation using RPM packages generates an initial random password, which is written to the server error log. For data directory initialization performed manually using mysqld --initialize, mysqld generates an initial random password, marks it ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
The IGNORE modifier causes MySQL to ignore ignorable errors during the process of deleting rows. (Errors encountered during the parsing stage are processed in the usual manner.) Errors that are ignored due to the use of IGNORE are returned as ...
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
DROP ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. By default, an error occurs if you try to drop a role that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each ...DROP ROLE removes one or more roles (named collections of ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
Use of multiple operators on a single search word returns a syntax error to standard out. Specifying a trailing plus or minus sign causes InnoDB to report a syntax error. MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group Replication. It might work, but chances are that the operations race and then the act of joining the group ends up in an error or a time out. If the group members have a value set for one of these system variables, and a joining member has a different value set for it, the joining member cannot join the group and an error message is ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
When the timeout specified by group_replication_unreachable_majority_timeout elapses, all pending transactions that have been processed by the member and the others in the minority group are rolled back, and the servers in that group move to the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
Starting the server with --log-error-verbosity=3 logs additional information to the error log during an online buffer pool resizing operation. You can configure InnoDB buffer pool size offline or while the server is running. For additional ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
Attempting to use an index key prefix length that exceeds the limit returns an error. ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed The maximum row size, excluding any variable-length columns that are stored off-page, is ...