PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
Account locking can be set or changed with the CREATE USER or ALTER USER statement. For the rules governing permissible Host and User values, see Section 6.2.4, “Specifying Account Names”. Rather, the password supplied by a user who is ...The ...
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. This remains true if the privileges needed to create the object are revoked from the account of ...If a definition omits the DEFINER attribute, the default object definer is the user who creates ...The DEFINER Attribute The SQL SECURITY Characteristic Examples Orphan Stored Objects Risk-Minimization Guidelines The ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
The option does not affect authentication (4.1 and later clients can still use accounts that have long password hashes), but it does prevent creation of a long password hash in the user table as the result of a password-changing operation. MySQL ...
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/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/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Use cases for this plugin include proxied accounts that ...
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/mysql-installer-workflow.html
It can optionally create MySQL server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and Backup Admin. The MySQL user accounts that you create in the next step will use the authentication ...It optionally creates a Windows user named MysqlSys with limited privileges, which would then run the MySQL ...