Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) and ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
On Unix and Unix-like systems, the file access mode is 644 for certificate files (that is, world readable) and 600 for key files (that is, accessible only by the account that runs the server). MySQL provides these ways to create the SSL certificate ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
You cannot use a cursor for a statement that generates a result set if the statement is not supported in prepared mode. Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-client.html
Do this by running mysql in debugging mode (assuming that you have compiled MySQL with debugging on): $> mysql --debug=d:t:O,/tmp/client.trace This provides useful information in case you mail a bug report. To be able to debug a MySQL client with ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
If you delete all rows in the table with DELETE FROM tbl_name (without a WHERE clause) in autocommit mode, the sequence starts over for all storage engines except InnoDB and MyISAM. DELETE is a DML statement that removes rows from a table. A DELETE ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
"Mounts": [ { "Type": "volume", "Name": "4f2d463cfc4bdd4baebcb098c97d7da3337195ed2c6572bc0b89f7e845d27652", "Source": "/var/lib/docker/volumes/4f2d463cfc4bdd4baebcb098c97d7da3337195ed2c6572bc0b89f7e845d27652/_data", "Destination": "/var/lib/mysql", ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-interfaces.html
To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document based applications. You can use MySQL Shell to prototype applications, execute queries ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
If the ANSI_QUOTES SQL mode is enabled, strings can be enclosed only by ' and the server interprets strings enclosed by " as identifiers. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if ...
https://dev.mysql.com/doc/refman/8.4/en/file-permissions.html
If this is unsuitable, create the error file manually with the desired access mode prior to executing mysqld_safe. For example, to give group access to all new directories, start mysqld_safe as follows: UMASK_DIR=504 # = 770 in octal export ... If ...