Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connecting-to-a-single-mysqld-node-setup.html
In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its password. You are prompted to enter the user name and password in this case.
https://dev.mysql.com/doc/refman/9.7/en/windows-start-service.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Windows. Finally, before trying to ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-predict-row.html
The input table must contain at least two columns with the same names as the user column and item column from the training model. , "item_k"), "column_rating_name" , JSON_ARRAY(rating_1, ..., rating_k)) The input table must contain at least one ...
https://dev.mysql.com/doc/refman/9.7/en/implicit-commit.html
This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction. ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. CREATE TABLE and DROP TABLE statements do not commit ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. If a ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-enterprise-audit.html
Enable it by setting the MySQL server system variable audit_log_disable to OFF in a custom configuration for your MySQL server and then use it to create your new DB system or update an existing one (see Creating a MySQL Configuration for details on ...You have to enable the plugin and define audit plugin filters to log auditable events for all or specific ... MySQL Enterprise Audit 3.1.2.7 MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. ndb_restore must be executed once for each of the backup files that were created by the START BACKUP command used to create the ...
https://dev.mysql.com/doc/refman/9.7/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The TABLESPACE option can be used with CREATE TABLE to create tables in a general tablespaces, file-per-table tablespace, or in the system tablespace. Creating a General Tablespace General tablespaces are created using CREATE TABLESPACE ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-disk-data-objects.html
It is possible to place these elsewhere by specifying either an absolute or relative path as part of the filename when creating the undo log or data file. Statements that create these files are shown later in this section. Create a tablespace; ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-tls.html
In order to obtain signed node certificates, it is necessary first to create a Certification Authority (CA). Only the administrator (DBA) should have access to the private CA signing key with which valid node certificates are created. Hostname ...