Search Results
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
In that case, the server writes messages similar to these to the error log during the startup process (the exact numbers may vary): [ERROR] Column count of mysql.user is wrong. Operations performed by a restricted client result in an error until the ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
For multithreaded replica operation, SHOW REPLICA STATUS reports all coordinator and worker thread errors using the Last_SQL_Errno and Last_SQL_Error fields, so only the most recent of those errors is visible and information can be lost. The ...This ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is rejected. A test plugin that checks ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | +--------+------------------+ Example 2. In strict mode, inserting a value that is out of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
replica_exec_mode: Allows for switching replication thread between IDEMPOTENT mode (key and some other errors suppressed) and STRICT mode; STRICT mode is default, except for NDB Cluster, where IDEMPOTENT is always used. replica_skip_errors: Tells ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-mbr.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
For an event, an error occurs at event execution time if the account does not exist. For a view, an error occurs when the view is referenced if the SQL SECURITY value is DEFINER but the definer account does not exist. (That is, the statement fails ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-reset.html
Otherwise, the command fails, as shown here: mcm> reset DataMemory mycluster; ERROR 3 (00MGR): Illegal syntax You also cannot revert all configuration attributes for a given process type or instance of a process using a single filter specification; ... reset [--sequential-restart] filter_specification_list cluster_name filter_specification_list: filter_specification[,filter_specification][,...] filter_specification: attribute_name[:process_specification][+process_specification]] process_specification: [process_name][:process_id] process_name: {ndb_mgmd|ndbd|ndbmtd|mysqld|ndbapi} This command resets an attribute to its default ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-load-plugin.html
An error occurs if the type is invalid or the plugin cannot be loaded. An error occurs if you try to load a plugin of a type already loaded. Errors To check for errors, call the mysql_error() or mysql_errno() function. Example MYSQL mysql; ...