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/performance-schema-statement-summary-tables.html
For other summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, ...Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
mysql> UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%events_statements_%'; mysql> UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%events_stages_%'; Under the user account you are ...
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/cast-functions.html
Cast Function and Operator Descriptions Character Set Conversions Character Set Conversions for String Comparisons Other Uses for Cast Operations Cast Function and Operator Descriptions BINARY expr The BINARY operator converts the expression to a ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
A “login path” is an option group that permits only certain options: host, user, password, port and socket. If multiple instances of a given option are found, the last instance takes precedence, with one exception: For mysqld, the first instance ...[group] group is the name of the program or group for which you want to set ...(For mysqld, use --verbose and --help.) If the program reads option files, 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/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Have your application connect to the database using a user name different from the one you use for ...Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character sequences in Web forms, URLs, or whatever application you have ...
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/mysql-tips.html
Connection id: 1 Current database: test Query OK, 1 row affected (1.30 sec) mysql> SELECT * FROM t; +------+ | a | +------+ | NULL | +------+ 1 row in set (0.05 sec) The @a user variable has been lost with the connection, and after the reconnection ...However, even if mysql succeeds in reconnecting, your first connection has ended and all your previous session objects and settings are lost: temporary tables, the autocommit mode, and user-defined and session ...Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) ...
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 ...