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/windows-pluggable-authentication.html
If that user is named Rafal or Tasha, or is a member of the Administrators or Power Users group, the server grants access and the client is authenticated as sql_admin and has whatever privileges are granted to the sql_admin account. In addition, ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
FLUSH PRIVILEGES Re-reads the privileges from the grant tables in the mysql system database. Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
The standard says that the definer of the view, which is the same as the owner of the view's schema, gets applicable privileges on the view (for example, SELECT) and may grant them. The DEFINER and SQL SECURITY clauses specify the security context ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
Grant the EXECUTE privilege for specific stored programs to the individual users who should be able to invoke them. This technique enables keys to be shared among users and provides to DBAs more fine-grained control over who can do what with keys, ...A user must possess the global EXECUTE privilege to use any keyring ... MySQL Server supports a keyring service that enables internal server components ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
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 statements that it contains, such as the appropriate CREATE privileges for objects ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Grant System Tables These system tables contain grant information about user accounts and the privileges held by them: user: User accounts, global privileges, and other nonprivilege columns. For more information about the structure, contents, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Privileges are as for other databases and tables: To retrieve from performance_schema tables, you must have the SELECT privilege. To change those columns that can be modified, you must have the UPDATE privilege. To truncate tables that can be ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
This means that if you migrate users from a MySQL 5.6 server (any version) to one running MySQL 5.7, you must make sure to grant this privilege explicitly to any users which need to be able to create foreign keys. Incompatible change: MySQL 5.6.22 ... Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
(For a discussion of concepts involved in proxying, see Section 6.2.14, “Proxy Users”.) An account that authenticates using mysql_no_login may be used as a proxied user for proxy accounts: -- create proxied account CREATE USER ...Use cases for ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
Do not grant the PROCESS or SUPER privilege to nonadministrative users. Make sure that the only Unix user account with read or write privileges in the database directories is the account that is used for running mysqld. This is extremely dangerous, ... When you connect to a MySQL server, you should use a ...