PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replication metadata repositories (see Section 16.2.4.2, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking the EVENT privilege from a user does not delete or disable any events that may ...An event is not migrated or dropped as a result of renaming or dropping the user who created ... To enable or disable the execution ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Table 6.26 Event Class and Subclass Combinations Event Class Event Subclass Description connection connect Connection initiation (successful or unsuccessful) connection change_user User re-authentication with different user/password during session ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
If the --login-path option is specified, the user, host, and password values are taken from the login path and used to create the administrative account. Secure-by-Default Deployment Current versions of mysql_install_db produce a MySQL deployment ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
The user table row for an account indicates the account privileges that apply on a global basis no matter what the default database is. These privileges can come from any of the user, db, tables_priv, columns_priv, or procs_priv tables. (You may ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_default_row_format Command-Line Format --innodb-default-row-format=value System Variable innodb_default_row_format Scope Global Dynamic Yes Type Enumeration Default Value DYNAMIC Valid Values REDUNDANTCOMPACTDYNAMIC The ... System variables ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
The audit log filtering functions enable filtering control by providing an interface to create, modify, and remove filter definitions and assign filters to user accounts. Multiple filters can be defined, and any given filter can be assigned to any ...Note By default, rule-based audit log filtering logs no auditable events for any ... Note As of MySQL 5.7.13, for audit log filtering to work as described here, ...
https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program. To associate MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-ssl-rsa-setup.html
--uid=name, -v Command-Line Format --uid=name The name of the user who should be the owner of any created files. In the absence of this option, files created by mysql_ssl_rsa_setup are owned by the user who executes it. This program creates the SSL ...Note mysql_ssl_rsa_setup uses the openssl command, so its use is contingent on having OpenSSL installed on your ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). Creating a foreign key constraint requires the REFERENCES privilege on the parent table. Such an index is created on the referencing ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...