Search Results
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. Specifying the CHARACTER ...These might be changes to a data type, to attributes associated with a data type, or to an index ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file.
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-installation.html
To avoid this overhead, do not install it unless you plan to use it. This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, called the view ... Some ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-backup-cluster.html
backup cluster [--backupid=backup_id] [--snapshotstart | --snapshotend] [--waitstarted | --waitcompleted] [--password-file=filepath] cluster_name This command creates a backup of the MySQL NDB Cluster named cluster_name. By default, this command ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-proxy-users.html
Use the CREATE USER or GRANT statement to associate accounts with plugins. This string comes from the AS part of the IDENTIFIED WITH clause of the CREATE USER statement that specifies use of the plugin for authentication. For example: CREATE USER ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-from-group-replication.html
If you have an existing deployment of Group Replication and you want to use it to create a cluster, pass the adoptFromGR option to the dba.createCluster() function. The created InnoDB Cluster matches whether the replication group is running as ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysqlsh.html
For MySQL Shell connections using classic MySQL protocol, specify the name of the authentication plugin used by the user account, for example caching_sha2_password (which is the default for user accounts created in MySQL 8.0). --mysql, --mc Sets the ... MySQL Shell is an advanced command-line client and code editor for ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-classification-overview.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE classification_data; mysql> USE ... This topic ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-preparing-a-recommendation-model.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE recommendation_data; mysql> USE ... This topic ...