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/grant.html
To grant a privilege with GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are granting. (Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system database, you can grant any ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE ...The discussion here describes the underlying structure of the grant tables and how the server uses their contents when interacting with ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
After the copies are created, mysql_cluster_move_privileges invokes mysql_cluster_move_grant_tables, which contains the ALTER TABLE ... Normally, you should not invoke either mysql_cluster_backup_privileges or mysql_cluster_move_grant_tables ... NDB ...This support is not enabled by default; you should follow the procedure outlined in this section in order to do ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be executed to duplicate the privilege assignments. SHOW GRANTS requires the SELECT privilege for the ...Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER ...For additional ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
The privileges granted to a MySQL account determine which operations the account can perform. These privileges can be granted for specific databases, or globally so that they apply to all databases. Privileges for database objects such as tables, ...MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage operation of the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
Suppose that the user jon@ghidora has been granted the EVENT and INSERT privileges on the myschema schema. mysql.user.Event_priv is set to 'Y' for a given user only if that user has the global EVENT privilege (that is, if the privilege was bestowed ...The EVENT privilege governs the creation, modification, and deletion of ... To enable or disable the execution of scheduled events, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The SQL statements used to grant and revoke privileges on NDB tables, databases containing ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
If you modify the grant tables directly using statements such as INSERT, UPDATE, or DELETE (which is not recommended), the changes have no effect on privilege checking until you either tell the server to reload the tables or restart it. This may ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. The exact list of privileges depends on the version of your ...