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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
The Performance Schema exposes metadata lock information through the metadata_locks table: Locks that have been granted (shows which sessions own which current metadata locks). Locks that have been requested but not yet granted (shows which sessions ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 8.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now sets the access control granted to clients on the named pipe to the minimum necessary for successful communication on Windows. The value of the show_compatibility_56 system variable affects the output produced from and privileges required ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine creator. If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 23.6, “Stored Object Access ...By ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
This is true even if you precede the password command with flush-privileges on the same command line to re-enable the grant tables because the flush operation occurs after you connect. However, you can use mysqladmin flush-privileges to re-enable ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Connect to the MySQL server using the mysql client; no password is necessary because the server was started with --skip-grant-tables: $> mysql In the mysql client, tell the server to reload the grant tables so that account-management statements ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
Replicated statements executed on a replica are processed by the replica SQL thread, which has full privileges. It is possible for a procedure to follow different execution paths on source and replica servers, so a user can write a routine ... The ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
Learn how the MySQL access privilege system works (see Section 6.2, “Access Control and Account Management”). Use the GRANT and REVOKE statements to control access to MySQL. If you are able to connect successfully to the server without being ...