Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-replicaset-instances.html
The preferred method to create users to administer a ReplicaSet is using the setupAdminAccount() operation. When you connect to the instance for administration tasks, you require a user with suitable privileges. Alternatively, the ... Use ...
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 ...Note MySQL HeatWave AutoML is supported on DB Systems with 32 or less MySQL HeatWave Cluster nodes ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-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 ... Note The Audit Log component is intended to replace the Audit Log plugin, which is now ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...