PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-privileges.html
The same thing is true with respect to the CREATE USER and DROP USER statements. The only tables that would be safe from this sort of mayhem would be those tables that were created using storage engines other than NDB, and so not visible to a ... In ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-oci-marketplace-deploy.html
See To create a Linux instance for information on how to complete the fields. /etc/my.cnf.d/perf-tuning.cnf is created by /usr/bin/mkcnf based on the selected OCI shape. To deploy MySQL EE on Oracle Cloud Infrastructure, do the following: Open the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. The .sql file contains a CREATE TABLE statement for the table. The server sends the CREATE definitions for dumped tables to mysqldump, which writes them to .sql files.
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
To create or modify a login path file, use the mysql_config_editor utility. Here is a sample session that demonstrates use of mysqlimport: $> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test $> ed a 100 Max Sydow 101 Count Dracula . The ...
https://dev.mysql.com/doc/refman/8.0/en/no-matching-rows.html
If you still cannot figure out what is wrong, create a minimal test that can be run with mysql test < query.sql that shows your problems. You can create a test file by dumping the tables with mysqldump --quick db_name tbl_name_1 ... Verify that the ... If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
For example, put these lines in your server my.cnf file: [mysqld] persist_only_admin_x509_subject="subject-value" The format of the Subject value is the same as used for CREATE USER ... SET PERSIST and SET PERSIST_ONLY enable global system ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ... If such statements are logged by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
THREAD_ID The thread ID of the session that created the lock. THREAD_ID can be used together with EVENT_ID to determine the event during which the lock data structure was created in memory. In practice, InnoDB always creates an index ...For ...