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/replication-encrypted-connections.html
If you want to ensure that the source only accepts replicas that connect using encrypted connections, create a replication user account on the source using the REQUIRE SSL option, then grant that user the REPLICATION SLAVE privilege. For example: ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. The exact list of privileges depends on the version of your ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
If the server is unable to access the data directory it starts or read the grant tables in the mysql database, it writes a message to its error log. Such problems can occur if you neglected to create the grant tables by initializing the data ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
(See Section 6.2.3, “Grant Tables”.) Resource-use counting takes place when any account has a nonzero limit placed on its use of any of the resources. The counts also can be reset by reloading the grant tables (for example, with a FLUSH ... One ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and ... The validate_password plugin serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft Windows. The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
See Section 13.1.33, “RENAME TABLE Statement”.) Privileges granted specifically for the renamed table are not migrated to the new name. ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”. The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been requested and how many numbers are ... The INNODB_SYS_TABLESTATS table provides a view of low-level status information about InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
For example: --innodb-temp-data-file-path=../../../tmp/ibtmp1:12M:autoextend Usage Scenarios This mode of operation is appropriate in situations such as: Distributing a MySQL application, or a set of MySQL data, on a read-only storage medium such as ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
This is intended to prevent excessive CPU usage in the event of repeated failures. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and ...