MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 21 to 30 of 1234 total results

2.9.4 Securing the Initial MySQL Account

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 ...

6.2 Access Control and Account Management

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 ...

15.8.2.2 Creating a FEDERATED Table Using CREATE SERVER

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 ...

13.1.18.1 Files Created by CREATE TABLE

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 ...

6.2.3 Grant Tables

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, ...

13.7.5.12 SHOW CREATE USER Statement

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 ...

26.4.5.9 The ps_is_account_enabled() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-account-enabled.html

Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...

13.1.21 CREATE VIEW Statement

https://dev.mysql.com/doc/refman/5.7/en/create-view.html

If the DEFINER clause is present, the user value should be a MySQL account specified as 'user_name'@'host_name', CURRENT_USER, or CURRENT_USER(). If the DEFINER clause is omitted, the default definer is the user who executes the CREATE VIEW ...If ...

13.1.20 CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html

MySQL takes the DEFINER user into account when checking trigger privileges as follows: At CREATE TRIGGER time, the user who issues the statement must have the TRIGGER privilege. CREATE [DEFINER = user] TRIGGER trigger_name trigger_time ...CREATE ...

26.4.5.14 The ps_thread_account() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-account.html

Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. Example mysql> SELECT ...The value should match the ...

Displaying 21 to 30 of 1234 total results