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/audit-log-file-formats.html
For example, Create DB and Change user correspond to COM_CREATE_DB and COM_CHANGE_USER, respectively. Example: <MYSQL_VERSION>5.7.21-log</MYSQL_VERSION> <OS_LOGIN> A string representing the external user name used during the authentication process, ...To select the log format that the audit log plugin uses to write its log file, set the audit_log_format system variable at server ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
| @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that affect the operation of the server or clients: User-defined variables. This statement assigns a value to a user-defined ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. --user=user_name, -u user_name Command-Line Format --user=user_name ...It dumps one or more MySQL databases for backup or transfer to another SQL ...The ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
Run the following command: mysqlsh -u user -h localhost --classic --dba enableXProtocol Using the MySQL Client program: Open a terminal window (command prompt on Windows) and navigate to the MySQL binaries location (for example, /usr/bin/ on Linux).
https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html
Users who have logged in to Windows can connect from MySQL client programs to the server based on the information in their environment without specifying an additional password. To set this up, create a MySQL account named sql_admin that uses the ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
(These are both empty by default, so if they are not set, the LDAP server must permit anonymous connections.) The resulting bind LDAP handle is used to search for the user DN, based on the client user name. authentication_ldap_sasl performs a second ...If the base DN is ou=Admin,dc=example,dc=com: Searches find user entries only in the second ...The client-side and server-side SASL LDAP plugins use SASL messages for secure transmission of credentials ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. FROM is a consistent read, reading ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. Caution Because a global privilege is considered a privilege for all databases, any global privilege enables a ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.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. --user=user_name, -u user_name Command-Line Format ...If ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. For ...