PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
In MySQL 5.7 you can instead use an InnoDB table named mysql.slave_relay_log_info to store the applier metadata repository. As a table, updates to the applier metadata repository are committed together with the transactions, meaning that the ... In ...
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
Changes affecting operations in strict SQL mode (STRICT_TRANS_TABLES or STRICT_ALL_TABLES) may result in replication failure on an upgraded replica. If you have upgraded to a release earlier than MySQL 8.0.16, invoke mysql_upgrade manually to ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
The statement does not change the values of gtid_executed or gtid_purged, or the mysql.gtid_executed table. From MySQL 5.7.24, when master_info_repository=TABLE is set on the server, replication connection parameters are preserved in the crash-safe ... RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE makes the replica forget its replication position in the source's binary ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Alternatively, on any platform, you can reset the password using the mysql client (but this approach is less secure): Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option. Because this is insecure, you might want ... If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
Running mysqld as a Unix user other than root does not mean that you need to change the root user name in the user table. This includes the server's data directory containing the files that implement the privilege tables. INTO OUTFILE do not ...
https://dev.mysql.com/doc/refman/5.7/en/server-side-help-support.html
This information is stored in several tables in the mysql database (see Section 5.3, “The mysql System Database”). Proper operation of the HELP statement requires that these help tables be initialized. For a new installation of MySQL using a ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. By ...It ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object body. p2 fails if the invoker lacks the EXECUTE privilege for p2 or the UPDATE privilege for the table t1. The server ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...