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/access-control.html
MySQL handles this by enabling you to distinguish users on different hosts that happen to have the same name: You can grant one set of privileges for connections by joe from office.example.com, and a different set of privileges for connections by ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
For foreground threads, the initial INSTRUMENTED value is determined by whether the user account associated with the thread matches any row in the setup_actors table. setup_actors is not consulted because there is no associated user for background ...row *************************** THREAD_ID: 51 NAME: thread/sql/one_connection TYPE: FOREGROUND PROCESSLIST_ID: 34 PROCESSLIST_USER: isabella PROCESSLIST_HOST: localhost PROCESSLIST_DB: performance_schema PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 0 PROCESSLIST_STATE: Sending data PROCESSLIST_INFO: SELECT * FROM performance_schema.threads PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 755399 ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system database. If the IF EXISTS clause is given, the statement produces a warning for each named user that does not exist, rather than an error. For example: DROP USER 'jeffrey'@'localhost'; The host name part of the account name, if omitted, defaults to ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
The name of a user variable used for this purpose must match the name of a field from the XML file, prefixed with @. User variables can be employed to store the corresponding field values for subsequent re-use. As mentioned previously, you can use a ...(Bug #30753708, Bug #98199) The following clauses work essentially the same way for LOAD XML as they do for LOAD DATA: LOW_PRIORITY or CONCURRENT LOCAL REPLACE or IGNORE CHARACTER SET SET See Section 13.2.6, “LOAD DATA Statement”, for more information about these ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
query-start(query, connectionid, database, user, host) query-done(status) query-start: Triggered after the query string has been received from the client. connection-start(connectionid, user, host) connection-done(status, connectionid) ...To ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. Mar 7 12:39:25 myhost MysqlClient[20824]: ...For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
Note When ndbinfo_show_hidden is enabled, the internal tables are shown in the ndbinfo database only; they are not visible in TABLES or other INFORMATION_SCHEMA tables, regardless of the variable's setting. Set to OFF to keep this from happening; ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION. To determine the ...If ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary users. (For a discussion of concepts involved in proxying, see Section 6.2.14, ...For example, put these lines in the server my.cnf file, adjusting the .so suffix for your platform as necessary: [mysqld] plugin-load-add=mysql_no_login.so After modifying my.cnf, restart the server to cause the new settings to take ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should assign passwords to the MySQL root account in the grant tables. On Linux, for installations performed using a MySQL repository, RPM packages, or Debian ...If ...If it does not, you must also follow those links and change the directories and files they point ...