Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same region. This task requires the following: A client ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-updating-egress-endpoints.html
Knowledge of the new hostname or port in your AWS account, or the new DB System ID for which you want to allow connectivity. Under Target DB System: Update the DB System connected to this Egress PrivateLink. Updating Egress Endpoints for a Egress ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements-callable.html
Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 7.4 Connector/J: Using Connection.prepareCall() import java.sql.CallableStatement; ... For performance reasons, ...For more information on MySQL stored procedures, please refer to Using Stored ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
To kill a session or statement that is executing with the SYSTEM_USER privilege, your own session must have the SYSTEM_USER privilege, in addition to any other required privilege (CONNECTION_ADMIN or the deprecated SUPER privilege). If the user that ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-reading.html
For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, "class": "connection", "event": "connect", ... }, { "timestamp": "2020-05-18 13:39:33", "id": 2, "class": "connection", "event": "disconnect", ... The audit log plugin supports functions ...
https://dev.mysql.com/doc/refman/8.4/en/cleartext-pluggable-authentication.html
To avoid problems if there is any possibility that the password would be intercepted, clients should connect to MySQL Server using a method that protects the password. Possibilities include SSL (see Section 8.3, “Using Encrypted Connections”), ... A client-side authentication plugin is available that enables clients to send passwords to the server as cleartext, without hashing or ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. An error is reported if an encrypted connection is not available or the REQUIRE NO ...
https://dev.mysql.com/doc/refman/8.4/en/create-server.html
Note The OWNER option is currently not applied, and has no effect on the ownership or operation of the server connection that is created. For example: CREATE SERVER s FOREIGN DATA WRAPPER mysql OPTIONS (USER 'Remote', HOST '198.51.100.106', DATABASE ... CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER character-literal | PORT numeric-literal } This statement creates the definition of a server for use with the FEDERATED storage ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
Note Older versions of MySQL used a COMMENT option for the connection string. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; ...