Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-creating.html
On the Create MySQL HeatWave Cluster dialog, provide the following information: Basic Information Display Name: Specify a user-friendly display name for the MySQL HeatWave Cluster. Creating a MySQL HeatWave Cluster 4.1 Creating a MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
As of MySQL 9.3.0, you can create temporary tables that are stored in the MySQL HeatWave Cluster. Once created, you can use a MySQL HeatWave temporary table as an independent entity. After the MySQL HeatWave temporary table is created, you can ...A ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-cluster.html
create cluster {--package=|-P }package_name {--processhosts=|-R }process_host_list cluster_name [(--import|-m) cluster_name] [--verbose | -v] process_host_list: process_name[:node_id]@host[,process_name@host[,...]] process_name: ...However, it does ...
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
Users should not create SRSs with SRIDs in the reserved ranges. srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This ...The ...