Search Results
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
If the key file contains a valid public key value but the value is incorrect, an access-denied error occurs. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
In the latter case, the error log should contain a reason indicating why the option is disabled. SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-doxygen.html
Open an administrator console and run this command: $> java -jar path-to-plantuml.jar The command should open a GUI window and return no errors on the console. Next, generate the doxygen documentation: $> make doxygen Inspect the error log, which is ... The MySQL source code contains internal documentation written using ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
If you encounter build errors such as internal compiler error when compiling large source files, it may be that you have too little memory. Some of these tools are needed no matter whether you use a standard source distribution or a development ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
For compliance with the SQL standard, which states that diagnostics statements are not preparable, MySQL does not support the following as prepared statements: SHOW COUNT(*) WARNINGS SHOW COUNT(*) ERRORS Statements containing any reference to the ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server.html
If the command fails immediately and prints mysqld ended, look for information in the error log (which by default is the host_name.err file in the data directory). If the server is unable to access the data directory it starts or read the grant ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the function. READ statements that invoke ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
MySQL does not support LIMIT in subqueries for certain subquery operators: mysql> SELECT * FROM t1 WHERE s1 IN (SELECT s2 FROM t2 ORDER BY s1 LIMIT 1); ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ... In general, you cannot modify a table and select from the same table in a ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
For example, you cannot select from the mysql.schemata table directly: mysql> SELECT * FROM mysql.schemata; ERROR 3554 (HY000): Access to data dictionary table 'mysql.schemata' is rejected. Account-management statements are transactional and either ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
Otherwise, use of a named time zone results in an error: mysql> SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC' Populating the Time Zone Tables Several tables in the mysql system schema exist to store time zone ...