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/request-access.html
This is where the privilege columns in the grant tables come into play. (You may find it helpful to refer to Section 6.2.3, “Grant Tables”, which lists the columns present in each grant table.) The user table grants global privileges. For ...For ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Of these, some can request that the MySQL server itself map proxy users according to granted proxy privileges: mysql_native_password, sha256_password. At runtime, setting a global system variable value requires the SUPER privilege. Setting a session ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege for the ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
After deleting the row, remember to issue a FLUSH PRIVILEGES statement to reload the grant tables. If you change the grant tables directly (for example, by using INSERT, UPDATE, or DELETE statements) and your changes seem to be ignored, remember ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
Grant to the proxy account the PROXY privilege for each proxied account: GRANT PROXY ON 'developer'@'localhost' TO ''@''; GRANT PROXY ON 'data_entry'@'localhost' TO ''@''; Use the mysql command-line client to connect to the MySQL server as antonio.
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
For details on the levels at which privileges exist, the permissible priv_type, priv_level, and object_type values, and the syntax for specifying users and passwords, see Section 13.7.1.4, “GRANT Statement”. To use the first REVOKE syntax, you ...The REVOKE statement enables system administrators to revoke privileges from MySQL ...Each ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
Additional functionality includes the ability to grant privileges for administrative operations. When you issue requests after connecting, the system grants privileges according to your identity and what you want to do. MySQL handles this by ...The ... MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
Grant to the proxy account the PROXY privilege for each proxied account: GRANT PROXY ON 'accounting'@'localhost' TO ''@'%'; GRANT PROXY ON 'front_office'@'localhost' TO ''@'%'; Use the mysql command-line client to connect to the MySQL server as ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
Administrators can prevent users from creating stored objects that specify highly privileged DEFINER accounts by not granting them the SUPER privilege. In some cases, you can prevent references to these objects by not granting unauthorized users ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
The SELECT privilege on the mysql system database is required to dump user definitions. Certain options might require other privileges as noted in the option descriptions. To reload a dump file, you must have the privileges required to execute the ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...