PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
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 mysql User and Group for details). To switch to the mysql user on your ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
If you did not have binary logging enabled when you configured the user credentials on s1, you must create the replication user on s2. In this case, connect to s2 and issue: SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT ...17.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_stages_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST columns. Each row summarizes events for a given account (user and host combination) and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_transactions_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) ...Each row summarizes events for a given user and event ... The Performance Schema maintains tables for collecting current and recent transaction ...
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/performance-schema-query-profiling.html
The setup_actors table can be used to limit the collection of historical events by host, user, or account to reduce runtime overhead and the amount of data collected in history tables. mysql> UPDATE performance_schema.setup_consumers SET ENABLED = ...The first step of the example shows how to limit collection of historical events to a specific ... The following example demonstrates how to use Performance Schema statement events and stage events to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination). For each new foreground thread, the Performance Schema matches the user and host for the thread against the ...
https://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html
Once you know the proper parameters, you should be able to connect like this: $> mysql -h host -u user -p Enter password: ******** host and user represent the host name where your MySQL server is running and the user name of your MySQL account. To ...If the server runs on a machine other than the one where you log in, you also need to specify a host ...
https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html
For example: $> mysql --user=testuser --password Enter password: testpassword The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string column of the account row in the mysql.user ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
The following example creates a simple rule to match statements that select a single literal value: INSERT INTO query_rewrite.rewrite_rules (pattern, replacement) VALUES('SELECT ?', 'SELECT ? + 1'); The resulting table contents look like this: ...