MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 201 to 210 of 218 total results

16.3.8 Setting Up Replication to Use Encrypted Connections

https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html

For example: mysql> CREATE USER 'repl'@'%.example.com' IDENTIFIED BY 'password' -> REQUIRE SSL; mysql> GRANT REPLICATION SLAVE ON *.* -> TO 'repl'@'%.example.com'; If you have an existing replication user account on the source, you can add REQUIRE ... To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network ...

16.4.1.37 Replication and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html

In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica ...

16.1.5.1 Configuring Multi-Source Replication

https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-configuration.html

A multi-source replication topology requires at least two sources and one replica configured. In these tutorials, we assume you have two sources source1 and source2, and a replica replicahost. The replica replicates one database from each of the ...

16.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging

https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html

These functions include FOUND_ROWS(), GET_LOCK(), IS_FREE_LOCK(), IS_USED_LOCK(), LOAD_FILE(), MASTER_POS_WAIT(), PASSWORD(), RAND(), RELEASE_LOCK(), ROW_COUNT(), SESSION_USER(), SLEEP(), SYSDATE(), SYSTEM_USER(), USER(), UUID(), and UUID_SHORT().

16.3.1.1 Backing Up a Replica Using mysqldump

https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html

Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database ...

16.3.7 Switching Sources During Failover

https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html

To use CHANGE MASTER TO, add all information about how to connect to Replica 1 from Replica 2 or Replica 3 (user, password, port). You can tell a replica to change to a new source using the CHANGE MASTER TO statement. The replica does not check ...

13.4.2.3 RESET SLAVE Statement

https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html

RESET SLAVE does not change any replication connection parameters such as the source's host name and port, or the replication user account name and its password. RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE ...

13.7.1.6 REVOKE Statement

https://dev.mysql.com/doc/refman/5.7/en/revoke.html

For details on the levels at which privileges exist, the permissible priv_type, priv_level, and object_type values, and the syntax for specifying users and passwords, see Section 13.7.1.4, “GRANT Statement”. The REVOKE statement enables system ...

6.1.7 Client Programming Security Guidelines

https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html

The preferred API's support the improved MySQL authentication protocol and passwords, as well as prepared statements with placeholders. Client applications that access MySQL should use the following guidelines to avoid interpreting external data ...

Chapter 6 Security

https://dev.mysql.com/doc/refman/5.7/en/security.html

These include choosing good passwords, not granting unnecessary privileges to users, ensuring application security by preventing SQL injections and data corruption, and others. When thinking about security within a MySQL installation, you should ...

Displaying 201 to 210 of 218 total results