Search Results
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
Users can create, modify, and drop scheduled events using SQL statements intended for these purposes. The default definer of an event is the user who created the event, unless the event has been altered, in which case the definer is the user who ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-tarball.html
When the agent runs for the first time, it creates a directory where the agent stores its own configuration data; by default, that is mcm_data in the parent directory of the MySQL Cluster Manager installation directory. In the second of these lines, ... Extract the MySQL Cluster Manager 8.4.6 program and other files from the distribution ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
It is strongly recommended that you never change the SQL mode once you have created tables employing user-defined partitioning. To determine the current global or session sql_mode setting, select its value: SELECT @@GLOBAL.sql_mode; SELECT ... The ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
What is a MySQL connection? Why might I need to create more than one? A.2. How do I create a MySQL database (schema) in MySQL Workbench? A.4. What is a MySQL connection? Why might I need to create more than one? A MySQL connection links (connects) ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-5.html
If a user creates a table with text columns that use a non-UTF-8 character set, and this column holds a string with non-ASCII characters, errors will occur for attempts to access that string (for example, in a query result). (WL #10785) X DevAPI ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
User-created data (schemas, tables, tablespaces) and binary logs on the recipient are removed before data is cloned to the recipient data directory. When user-created data and binary logs are removed from the recipient data directory during a remote ...For informational purposes, warnings are printed to the server error log to specify when data removal starts and finishes: [Warning] [MY-013453] [InnoDB] Clone removing all user data for provisioning: ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-restoring.html
The restored DB System uses the same MySQL Administrator user name and password that was in effect when the backup was created. Note: No administrator user name and password are requested, because the restored DB System uses the same administrator ... Restoring a Backup to a New DB System 18.4 Restoring a Backup to a New DB System When you restore a backup, you create a new DB System and restore the backup to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
To create summaries, use the following options: summarize_logs: Enable summaries by setting this to TRUE. For the option to set the user name, you can set it to NULL. The following example runs ML_PREDICT_TABLE on the testing dataset previously ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
Create the database first; its name should not exceed 64 characters. For example: mysql> CREATE DATABASE IF NOT EXISTS database-name; Next, run the script using the alternative database name. For new MySQL installations, the USER and HOST columns in ... This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 8.4.5.1, “Elements of MySQL Enterprise ...