Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-resource-group.html
CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, ...This ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-create.html
Creating a DB System 3.3 Creating a DB System Check that the correct AWS region is shown at the top of the MySQL HeatWave Console. If it is not, see: Manage Regions Creating a DB System requires the following information: Administrator credentials.
https://dev.mysql.com/doc/refman/9.7/en/create-temporary-table.html
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them. Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute ... You can use the TEMPORARY keyword when creating a ...A TEMPORARY table is visible only within the current ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/create-cluster.html
If you did not create an administration user when configuring your instances, use the Cluster.setupAdminAccount() operation. For example to create a user named icadmin that can administer the InnoDB Cluster assigned to the variable cluster, issue: ... Once you have prepared your instances, use the dba.createCluster() function to create the cluster, using the instance which MySQL Shell is connected to as the seed instance for the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-create-table-external.html
There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory. InnoDB supports the following methods for creating tables externally: Using the DATA DIRECTORY Clause Using CREATE TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-create-if-not-exists.html
CREATE USER is written to the binary log only if successful. If the statement includes IF NOT EXISTS, it is considered successful, and is logged as long as at least one user named in the statement is created; in such cases, the statement is logged ...IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the ...
https://dev.mysql.com/doc/refman/9.7/en/create-role.html
To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all ... CREATE ROLE [IF NOT EXISTS] role [, role ] ...If the IF NOT EXISTS clause is given, the statement produces a warning for each ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-create-configure.html
To create and then configure the target cluster, follow these steps: Install MySQL Cluster Manager and start mcmd on all hosts with the same system user who started the wild cluster processes. Important The cluster import is going to fail due to ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
Note An easier alternative to generating the files required for SSL than the procedure described here is to let the server autogenerate them; see Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. There is no ... This ...
https://dev.mysql.com/doc/refman/9.7/en/create-library.html
To execute CREATE LIBRARY, the user must have the CREATE ROUTINE privilege. To use a library created within a stored program using this statement, the user must have the EXECUTE privilege. CREATE LIBRARY [IF NOT EXISTS] [database.]library LANGUAGE ...Invalid code causes the statement to be rejected with an ...