MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 41 to 50 of 1234 total results

6.2.5 Access Control, Stage 1: Connection Verification

https://dev.mysql.com/doc/refman/5.7/en/connection-access.html

Account locking can be set or changed with the CREATE USER or ALTER USER statement. For the rules governing permissible Host and User values, see Section 6.2.4, “Specifying Account Names”. Rather, the password supplied by a user who is ...The ...

13.1.19 CREATE TABLESPACE Statement

https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html

If the directory specified does not exist, NDB attempts to create it; the system user account under which the data node process is running must have the appropriate permissions to do so. Considerations for InnoDB Considerations for NDB Cluster ...

13.1.17 CREATE SERVER Statement

https://dev.mysql.com/doc/refman/5.7/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 ...

6.3.3.3 Creating RSA Keys Using openssl

https://dev.mysql.com/doc/refman/5.7/en/creating-rsa-files-using-openssl.html

To create the RSA private and public key-pair files, run these commands while logged into the system account used to run the MySQL server so the files are owned by that account: openssl genrsa -out private_key.pem 2048 openssl rsa -in ... This ...

6.3.3.2 Creating SSL Certificates and Keys Using openssl

https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html

See Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. There is no extendedKeyUsage extension in SSL certificates created using the openssl command following the instructions in this topic. If you use your own client ...

13.1.14 CREATE INDEX Statement

https://dev.mysql.com/doc/refman/5.7/en/create-index.html

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...

13.1.18.7 CREATE TABLE and Generated Columns

https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html

A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ...Values of ...

2.3.4.2 Creating an Option File

https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html

Note When using the MySQL Installer to install MySQL Server, it creates the my.ini in the default location, and the user executing MySQL Installer is granted full permissions to this new my.ini file. In other words, be sure that the MySQL Server ...

15.8.2.1 Creating a FEDERATED Table Using CONNECTION

https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html

For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...The CONNECTION string contains the information required to connect to the remote server containing the table used for physical storage of the ...

13.7.5.9 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html

row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Create Procedure: CREATE ... SHOW CREATE ...

Displaying 41 to 50 of 1234 total results