Search Results
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
The server increments the Locked_connects status variable that indicates the number of attempts to connect to a locked account, returns an ER_ACCOUNT_HAS_BEEN_LOCKED error, and writes a message to the error log: Access denied for user ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
References to stored routines, loadable functions, and tables in such cases are specifically not permitted, and fail with an error (see Bug #22830). Although an ALTER EVENT statement that contains another ALTER EVENT statement in its DO clause ...
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER ...The ...
https://dev.mysql.com/doc/refman/8.4/en/arithmetic-functions.html
* Multiplication: mysql> SELECT 3*5; -> 15 mysql> SELECT 18014398509481984*18014398509481984.0; -> 324518553658426726783156020576256.0 mysql> SELECT 18014398509481984*18014398509481984; -> out-of-range error The last expression produces an error ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-reading.html
An audit_log_read() call to read events that does not specify a position produces an error under any of these conditions: A read sequence has not yet been initialized by passing a position to audit_log_read(). If an audit_log_read() argument ... The ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
For cases of truncation, to cause an error to occur (rather than a warning) and suppress insertion of the value, use strict SQL mode. For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. This means that, if the index requires unique values, duplicate-key errors occur for values ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-disconnecting.html
For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
If the server does not recognize the cost name when it reads this table, it writes a warning to the error log. If the server finds that the cost value is invalid (nonpositive) when it reads this table, it writes a warning to the error log. If the ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...