PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
Important When a table is dropped, privileges granted specifically for the table are not automatically dropped. Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
This function is the SQL interface to the algorithm used by the server to encrypt MySQL passwords for storage in the mysql.user grant table. It also influences password hashing performed by CREATE USER and GRANT statements that specify a password ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
How do I prevent GRANT and REVOKE statements from replicating to replica machines? A.14.13. How do I prevent GRANT and REVOKE statements from replicating to replica machines? Start the server with the --replicate-wild-ignore-table=mysql.% option to ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
In this case, connect to s2 and issue: SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
One way this might occur is that there is no account listed in the grant tables for davida. It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
When session 1 rolls back, it releases its exclusive lock on the row and the queued shared lock requests for sessions 2 and 3 are granted. When session 1 commits, it releases its exclusive lock on the row and the queued shared lock requests for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
Once granted, the duration of the exclusive metadata lock is brief. Session 3: mysql> SELECT * FROM t1; The SELECT statement issued in session 3 is blocked waiting for the exclusive metadata lock requested by the ALTER TABLE operation in session 2 ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
If the server is started with the --skip-grant-tables option, plugins registered in the mysql.plugin table are not loaded and are unavailable. If you need to load plugins for a single server startup when the --skip-grant-tables option is given ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable ...