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/charset-collation-compatibility.html
Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character set: mysql> SELECT _latin1 'x' COLLATE latin2_bin; ERROR 1253 (42000): COLLATION 'latin2_bin' is not valid for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...A good workaround is to state the character set and collation explicitly in CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read ...To kill threads belonging to other users, the connected user must have the SUPER ...You can use it to check ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-update-set-user.html
The sys_config_update_set_user trigger for the sys_config table is similar to the sys_config_insert_set_user trigger, but for UPDATE statements.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from running MySQL in a standard (non-Cluster) environment. Alternatively, you can start the MySQL server process with --user=mysql on ...You should also delete the anonymous user account that is installed by ...In general, any standard procedure for running ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-context-mysqld-tcp-port.html
If you configure mysqld to use a different TCP port, you may need to set the context for the new port. The default TCP port for mysqld is 3306; and the SELinux context type used is mysqld_port_t. For example to define the SELinux context for a ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html
utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, ... The utf8mb4 character set has these characteristics: Supports BMP and supplementary ...When converting utf8mb3 columns to ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
For example (enter the command on a single line): bin/mysqld --initialize --user=mysql --basedir=/opt/mysql/mysql --datadir=/opt/mysql/mysql/data Alternatively, put the relevant option settings in an option file and pass the name of that file to ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8.html
For more information, see Section 10.9.2, “The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)”.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
It removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. The Performance Schema also counts internal threads and threads for user sessions that failed to authenticate, using ...