Search Results
https://dev.mysql.com/doc/refman/9.7/en/encryption-functions.html
For a description of the permitted values of this variable, see Section 7.1.8, “Server System Variables”. Their return value is a string that has a character set and collation determined by the character_set_connection and collation_connection ...Caution Passwords or other sensitive values supplied as arguments to encryption functions are sent as cleartext to the MySQL server unless an SSL connection is ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-gtids.html
The GTIDs that are assigned to incoming transactions from clients use the group name specified by the group_replication_group_name system variable as the UUID part of the identifier, rather than the server UUID of the individual group member that ...
https://dev.mysql.com/doc/refman/9.7/en/innochecksum.html
Because checksum mismatches cause InnoDB to deliberately shut down a running server, it may be preferable to use this tool rather than waiting for an in-production server to encounter the damaged pages. innochecksum cannot be used on tablespace ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-user-credentials.html
They are applied whenever Group Replication is started, including automatic starts if the group_replication_start_on_boot system variable is set to ON. Alternatively, you can disable binary logging before creating the replication user, and then ...
https://dev.mysql.com/doc/refman/9.7/en/windows-create-option-file.html
If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option file. For options that are used every time the server starts, you may find it most convenient to use an option file ...However, to avoid confusion, it is best if you use only one ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-authentication-plugins-setup.html
To make the library file available for use, install it in the plugin directory (the directory named by the plugin_dir system variable). For example, to load the plugin at server startup, use a --plugin-load=auth_simple.so option, adjusting the .so ... To compile and install a plugin library file, use the instructions in Section 4.4.3, “Compiling and Installing Plugin ...
https://dev.mysql.com/doc/refman/9.7/en/create-tablespace.html
The value of the default_storage_engine system variable is used for ENGINE if the option is not specified. The rounding just described is done explicitly, and a warning is issued by the MySQL Server when any such rounding is performed. An undo ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-overview.html
NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for ...NDB ...
https://dev.mysql.com/doc/refman/9.7/en/changing-mysql-user.html
On Linux, for installations performed using a MySQL repository or RPM packages, the MySQL server mysqld should be started by the local mysql operating system user. To start the server as the given user automatically at system startup time, specify ... On Windows, you can run the server as a Windows service using a normal user ...If directories or files within the MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...On Windows, InnoDB always stores database and table names internally in ...