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 enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The user interface to MySQL accounts consists of SQL statements such as CREATE USER, GRANT, and REVOKE. To control which ...The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and ...
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/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/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/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/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/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/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.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/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 ...