PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html
To set this up, create a MySQL account named sql_admin that uses the Windows plugin for authentication: CREATE USER sql_admin IDENTIFIED WITH authentication_windows AS 'Rafal, Tasha, Administrators, "Power Users"'; The plugin name is ...Using ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--users Command-Line Format --users Type Boolean Default Value FALSE Dump user accounts as logical definitions in the form of CREATE USER and GRANT statements. mysqlpump dumps user accounts in logical form using CREATE USER and GRANT statements (for ...By default, mysqlpump does not dump user account definitions, even if you dump the mysql system database that contains the grant ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...If ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
Installation of MySQL creates only a 'root'@'localhost' superuser account that has all privileges and can do anything. This section describes how to assign a password to the initial root account created during the MySQL installation procedure, if ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. For information about the physical representation of a table, see ...| ...
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. For example, "Create DB" and "Change user" correspond to COM_CREATE_DB and COM_CHANGE_USER, respectively. Example: "account": { "user": "root", ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
Authentication uses either one or two LDAP bind operations, depending on whether the MySQL account names an LDAP user DN: If the account does not name a user DN: authentication_ldap_sasl performs an initial LDAP binding using ...The client-side ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
The storage engine for the table might create other files as well. For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the database directory. When an ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE to set up accounts and control the privileges available to each one. password_last_changed is updated by the CREATE USER, ALTER USER, ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
Account locking can be set or changed with the CREATE USER or ALTER USER statement. For the rules governing permissible Host and User values, see Section 6.2.4, “Specifying Account Names”. Rather, the password supplied by a user who is ...The ...