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/change-master-to.html
(Bug #11758581, Bug #50801) MASTER_USER and MASTER_PASSWORD are the user name and password of the account to use for connecting to the source. The password used for a replication user account in a CHANGE MASTER TO statement is limited to 32 ...(Bug ...(The complete text of a START SLAVE statement is also visible to SHOW PROCESSLIST.) Setting MASTER_SSL=1 for a replication connection and then setting no further MASTER_SSL_xxx options corresponds to setting --ssl-mode=REQUIRED for the client, as described in Command Options for Encrypted ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
The metadata requirements mean that the return values of the USER(), CURRENT_USER(), SESSION_USER(), SYSTEM_USER(), DATABASE(), and VERSION() functions have the UTF-8 character set by default. Thus column names, database names, user names, version ...This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
A password for the superuser is set and stored in the error log file. Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
For each new foreground thread, the Performance Schema matches the user and host for the thread against the rows of the setup_actors table. The setup_actors table contains information that determines whether to enable monitoring and historical ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
row *************************** CREATE USER for root@localhost: CREATE USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK The output ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
Important For users familiar with the ANSI/ISO SQL Standard, please note that no storage engine, including InnoDB, recognizes or enforces the MATCH clause used in referential integrity constraint definitions. Character data types (CHAR, VARCHAR, the ...By default, tables are created in the default database, using the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: memory_summary_by_account_by_event_name has USER, HOST, and EVENT_NAME columns. Each row summarizes events for a given account (user and host combination) and event name. Each row summarizes events for a given user and event ...It has these effects: In general, truncation resets the ...Operation counts help to ...Allocating a ...
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. When ...Account locking state is recorded in the account_locked column of the mysql.user system ...If the validate_password plugin is ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos | RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos | SQL_AFTER_MTS_GAPS } ...For ... START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...