Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-test-and-migrate.html
The following list contains some common errors you may encounter, and their likely causes: MySQL Cluster Manager requires a specific MySQL user and privileges to manage SQL nodes. If the mcmd MySQL user account is not set up properly, you may see No ... Testing and performing the migration of a standalone MySQL NDB Cluster into MySQL Cluster Manager consists of the following steps: Perform a test run of the proposed import using import cluster with the --dryrun ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
A stored routine that uses the database defaults when the routine is created includes those defaults as part of its definition. See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prereqs.html
The model catalog schema created by the ML_TRAIN procedure incorporates the user name in the schema name (for example, ML_SCHEMA_joesmith), and a period is not a permitted schema name character. MySQL User Names To use MySQL HeatWave AutoML, ensure ...Model and Table Sizes The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
Note A local cloning operation does not support cloning of user-created tables or tablespaces that reside outside of the data directory. All other user-created InnoDB tables and tablespaces, the InnoDB system tablespace, redo logs, and undo ...The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. SLAVE indicates that the tablespace is allocated for storing user-created temporary tables on a ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ... In particular, INSERT or UPDATE statements ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. The scope of a prepared statement is the session within which it is created, which as several implications: A prepared statement created in ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. MySQL uses security based ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-encrypted-connections.html
Encryption per connection is optional, but a specific user can be required to use encryption for X Protocol and MySQL Protocol connections by including an appropriate REQUIRE clause in the CREATE USER statement that creates the user. Alternatively, ... This section explains how to configure X Plugin to use encrypted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-scheduled-backups.html
Outputs from the stderr and stdout streams are redirected to /dev/null/, so they will not invoke other actions on the part of the Cron server (for example, email notifications to the user). Maintaining a regular backup schedule is an important ...