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/system-variable-privileges.html
This section describes the privileges required to assign values to system variables at runtime. Setting a global system variable runtime value requires the SUPER privilege. In contrast to setting global runtime values, setting session runtime values ... A system variable can have a global value that affects server operation as a whole, a session value that affects only the current session, or ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
GRANT and REVOKE assign privileges to and revoke privileges from accounts. This section discusses the following topics: Creating Accounts and Granting Privileges Checking Account Privileges and Properties Revoking Account Privileges Dropping ... To ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the column level; see Section 13.7.1.4, ...In ...TABLE_CATALOG The name of the catalog to which the table containing the column ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
The account for the proxied user must exist and be granted the privileges to be assumed by the proxy user. The server checks statements executed during the client session by employee_ext against the privileges granted to employee. Granting and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the schema level; see Section 13.7.1.4, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the table level; see Section 13.7.1.4, “GRANT ...TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 13.7.1.4, “GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
The mysql.user grant table defines the initial MySQL user account and its access privileges. If the root account has an empty password, your MySQL installation is unprotected: Anyone can connect to the MySQL server as root without a password and be ... The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/permission-optimization.html
Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. For example, if you do not grant any table-level or column-level privileges, the server need not ever ...