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-user.html
It removes privilege rows for the account from all grant tables. The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql ...An error occurs if you try to drop an account that does not ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
To create a temporary table, you must have the CREATE TEMPORARY TABLES privilege. After a session has created a temporary table, the server performs no further privilege checks on the table. One implication of this behavior is that a session can ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-example.html
The lock cannot be granted because it is incompatible with the S lock that client A holds, so the request goes on the queue of lock requests for the row and client B blocks. However, that lock request cannot be granted because client B already has a ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
MySQL grants table write locks as follows: If there are no locks on the table, put a write lock on it. MySQL grants table read locks as follows: If there are no write locks on the table, put a read lock on it. This section discusses internal ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
A non-root account can be used to install the plugin as long as the account has INSERT privilege for the mysql.plugin table. The mysqlxsys@localhost account is used by the X Plugin for authentication of external users against the MySQL account ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
Important When a database is dropped, privileges granted specifically for the database are not automatically dropped. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. DROP {DATABASE | SCHEMA} ...
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
For this to work, the user must have the SUPER privilege. 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 ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.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. --plugin-load, --plugin-load-add, and --early-plugin-load enable plugins to be loaded even when ... Server ...