Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-get-privileges.html
To use the additional features of MySQL HeatWave Cluster for different purposes, you might to ask your DB System administrator to create a new user account for you. By default, the DB System provides only one user account for the DB System ...This ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...If ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE to set up accounts and control the privileges available to each one. password_last_changed is updated by the CREATE USER, ALTER USER, ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
The output should be similar to this: $> klist Ticket cache: FILE:/tmp/krb5cc_244306 Default principal: karl@MYSQL.LOCAL Valid starting Expires Service principal 03/23/2021 08:18:33 03/23/2021 18:18:33 krbtgt/MYSQL.LOCAL@MYSQL.LOCAL Create a MySQL ...Applications are able to authenticate using a provided user name and password, or using a locally cached TGT or ST (for example, created using kinit or ...MySQL Enterprise Edition supports an ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
Installation of MySQL creates only a 'root'@'localhost' superuser account that has all privileges and can do anything. This section describes how to assign a password to the initial root account created during the MySQL installation procedure, if ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-files.html
For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the database directory. When an InnoDB table is created in the system tablespace, table data and ...The ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
row *************************** CREATE USER for u1@localhost: CREATE USER `u1`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS ... SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. It is also ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
{ "user":"Bob", "user_id":31, "zipcode":[94477,94536] } Creating multi-valued Indexes You can create a multi-valued index in a CREATE TABLE, ALTER TABLE, or CREATE INDEX statement. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-create-repl-user.html
Run the following SQL command to create a replication user, and to permit only encrypted connections for all accounts named by the statement. Creating a Replication User On a Source Server 8.4 Creating a Replication User On a Source Server The ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. For information about the physical representation of a table, see ...| ...