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/alter-table.html
See Section 13.1.33, “RENAME TABLE Statement”.) Privileges granted specifically for the renamed table are not migrated to the new name. To use ALTER TABLE, you need ALTER, CREATE, and INSERT privileges for the table. ALTER TABLE permits them ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). If ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
To assign privileges to this account, use one or more GRANT statements. To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system database. When the read_only system variable is enabled, CREATE ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...
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/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 ...
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 ...