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-setup-replicas.html
To do this, execute the following statement on the replica, replacing the option values with the actual values relevant to your system: mysql> CHANGE MASTER TO -> MASTER_HOST='source_host_name', -> MASTER_USER='replication_user_name', -> ...If the ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system variables. A character string literal may have an optional character ... Every character string literal has a character set and a ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. The effect of using MAX_BLOB_PART_SIZE in a column comment is to set the blob part size of a TEXT ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...It tells the parser, “the string that follows uses character set charset_name.” An introducer does not change the string to the introducer character set like CONVERT() would ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
mysql_upgrade checks mysql.user system table rows and, for any row with an empty plugin column, sets that column to 'mysql_native_password' or 'mysql_old_password' depending on the hash format of the Password column value. Important If you upgrade ...To correct this, reset the root password to unexpire it and run mysql_upgrade ... Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
For this purpose, a failed connection attempt is one for which the client user and host match a known MySQL account but the provided credentials are incorrect, or do not match any known account. Failed-connection counting is based on the user/host ...For example, put these lines in the server my.cnf file, adjusting the .so suffix for your platform as necessary: [mysqld] plugin-load-add=connection_control.so After modifying my.cnf, restart the server to cause the new settings to take ...
https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html
mysql> SELECT USER(); +---------------+ | USER() | +---------------+ | jon@localhost | +---------------+ 1 row in set (0.00 sec) This is not the same behavior as with the command line, where the equal sign is not required: $> mysql --user jon --host ...Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
The following items summarize other potential incompatibilities: SET NAMES 'utf8mb4' causes use of the 4-byte character set for connection character sets. For replication, if character sets that support supplementary characters are to be used on the ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the source. Optionally, create a separate user for ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're ...