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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
Other grant tables indicate privileges an account has for databases and objects within databases. Account names appear in SQL statements such as CREATE USER, GRANT, and SET PASSWORD and follow these rules: Account name syntax is ... MySQL account ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard pattern. For example, a GRANT statement, which updates the mysql.user ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Any account can be used for this operation, providing it has been granted the REPLICATION SLAVE privilege. To grant this account the privileges required for replication, use the GRANT statement. Therefore, you may want to create a separate account ... Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
Note Full permissions are granted to the user executing MySQL Installer to all generated files, such as my.ini. It optionally creates a Windows user named MysqlSys with limited privileges, which would then run the MySQL Server. When you select Named ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
To change the SQL mode at runtime, set the global or session sql_mode system variable using a SET statement: SET GLOBAL sql_mode = 'modes'; SET SESSION sql_mode = 'modes'; Setting the GLOBAL variable requires the SUPER privilege and affects the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
To grant the SUPER privilege to a user account, use this statement: GRANT SUPER ON *.* TO user; Alternatively, should you prefer to avoid granting the SUPER privilege while still permitting users to access specific filtering functions, “wrapper” ...To use any filtering function, a user must possess the SUPER privilege or an error ... Note As of MySQL 5.7.13, for audit log filtering to work as described ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
If transaction T1 holds a shared (S) lock on row r, then requests from some distinct transaction T2 for a lock on row r are handled as follows: A request by T2 for an S lock can be granted immediately. A request by T2 for an X lock cannot be granted ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Changing the setting at runtime requires privileges sufficient to set global system variables. Configuration at runtime requires privileges sufficient to set global system variables (see Section 5.1.8.1, “System Variable Privileges”) and ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. row *************************** OBJECT_TYPE: LOCKING SERVICE OBJECT_SCHEMA: ...