Privileges Index
   

Privileges Index

ALL

Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”

ALL PRIVILEGES

Section 5.4.1, “Privileges Provided by MySQL”

ALL [PRIVILEGES]

Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”

ALTER

Section 12.1.1, “ALTER DATABASE Синтаксис”
Section 12.1.7, “ALTER TABLE Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.1.32, “RENAME TABLE Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

ALTER ROUTINE

Section 12.1.4, “ALTER FUNCTION Синтаксис”
Section 12.1.5, “ALTER PROCEDURE Синтаксис”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.26, “DROP PROCEDURE and DROP FUNCTION Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 18.7, “Binary Logging of Stored Programs”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

CREATE

Section 12.1.7, “ALTER TABLE Синтаксис”
Section 12.1.10, “CREATE DATABASE Синтаксис”
Section 12.1.17, “CREATE TABLE Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.1.32, “RENAME TABLE Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE ROUTINE

Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 18.7, “Binary Logging of Stored Programs”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

CREATE TABLESPACE

Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE TEMPORARY TABLES

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE USER

Section 12.7.1.1, “CREATE USER Синтаксис”
Section 12.7.1.2, “DROP USER Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.1.4, “RENAME USER Синтаксис”
Section 12.7.1.5, “REVOKE Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE VIEW

Section 12.1.9, “ALTER VIEW Синтаксис”
Section 12.1.20, “CREATE VIEW Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section E.5, “Restrictions on Views”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

DELETE

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 12.2.2, “DELETE Синтаксис”
Section 12.7.3.2, “DROP FUNCTION Синтаксис”
Section 12.7.1.2, “DROP USER Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.2.8, “REPLACE Синтаксис”
Section 12.1.33, “TRUNCATE TABLE Синтаксис”
Section 12.7.3.4, “UNINSTALL PLUGIN Синтаксис”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”
Section 5.4.1, “Privileges Provided by MySQL”
Section 13.10, “The MERGE Storage Engine”
Section 22.3.2.6, “User-Defined Function Security Precautions”

DROP

Section 12.1.7, “ALTER TABLE Синтаксис”
Section 12.1.9, “ALTER VIEW Синтаксис”
Section 12.1.20, “CREATE VIEW Синтаксис”
Section 12.1.21, “DROP DATABASE Синтаксис”
Section 12.1.28, “DROP TABLE Синтаксис”
Section 12.1.31, “DROP VIEW Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.1.32, “RENAME TABLE Синтаксис”
Section 12.1.33, “TRUNCATE TABLE Синтаксис”
Section 17.3.1, “Management of RANGE and LIST Partitions”
Section 20.6, “Performance Schema General Table Characteristics”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 5.4, “The MySQL Access Privilege System”

EVENT

Section 12.1.2, “ALTER EVENT Синтаксис”
Section 12.1.11, “CREATE EVENT Синтаксис”
Section 12.1.22, “DROP EVENT Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.5.9, “SHOW CREATE EVENT Синтаксис”
Section 12.7.5.19, “SHOW EVENTS Синтаксис”
Section 18.4.1, “Event Scheduler Overview”
Section 18.4.3, “Event Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”

EXECUTE

Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.26, “DROP PROCEDURE and DROP FUNCTION Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 18.6, “Access Control for Stored Programs and Views”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

FILE

Section 12.7.1.3, “GRANT Синтаксис”
Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 12.2.7, “LOAD XML Синтаксис”
Section 12.2.9.1, “SELECT ... INTO Синтаксис”
Section 5.4.7, “Causes of Access-Denied Ошибки”
Описание
Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 11.5, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

GRANT OPTION

Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.1.5, “REVOKE Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

INDEX

Section 12.1.7, “ALTER TABLE Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

INSERT

Section 12.1.7, “ALTER TABLE Синтаксис”
Section 12.7.2.1, “ANALYZE TABLE Синтаксис”
Section 12.7.3.1, “CREATE FUNCTION Синтаксис for User-Defined Functions”
Section 12.7.1.1, “CREATE USER Синтаксис”
Section 12.1.20, “CREATE VIEW Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.2.5, “INSERT Синтаксис”
Section 12.7.2.4, “OPTIMIZE TABLE Синтаксис”
Section 12.1.32, “RENAME TABLE Синтаксис”
Section 12.7.2.5, “REPAIR TABLE Синтаксис”
Section 12.2.8, “REPLACE Синтаксис”
Section 18.6, “Access Control for Stored Programs and Views”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 13.2.1, “Pluggable Storage Engine Architecture”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”
Section 22.3.2.6, “User-Defined Function Security Precautions”

LOCK TABLES

Section 12.7.6.3, “FLUSH Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Синтаксис”
Описание
Section 5.4.1, “Privileges Provided by MySQL”

PROCESS

Section 12.7.1.3, “GRANT Синтаксис”
Глава 19, INFORMATION_SCHEMA Tables
Section 12.7.6.4, “KILL Синтаксис”
Section 13.3.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.7.5.30, “SHOW PROCESSLIST Синтаксис”
Section 5.5.2, “Adding User Accounts”
Section 18.4.2, “Event Scheduler Configuration”
Section 7.12.5, “Examining Thread Information”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.15, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 20.7.5.2, “The threads Table”

PROXY

Section 12.7.1.3, “GRANT Синтаксис”
Section 22.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.5.7, “Proxy Users”
Section 5.5.6.2.2.3, “Unix Password Authentication with Proxy Users and Group Mapping”
Section 5.5.6.3.2, “Using the Windows Authentication Plugin”

PROXY ... WITH GRANT OPTION

Section 5.5.7, “Proxy Users”

REFERENCES

Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

RELOAD

Section 12.7.6.3, “FLUSH Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.6.6, “RESET Синтаксис”
Section 21.9.3.55, “mysql_refresh()”
Section 21.9.3.56, “mysql_reload()”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Описание
Описание
Section 11.13, “Encryption and Compression Functions”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”

REPLICATION CLIENT

Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.5.24, “SHOW MASTER STATUS Синтаксис”
Section 12.7.5.35, “SHOW SLAVE STATUS Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”

REPLICATION SLAVE

Section 12.7.1.3, “GRANT Синтаксис”
Section 15.1.1.3, “Creating a User for Replication”
Section 5.4.1, “Privileges Provided by MySQL”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.3.7, “Setting Up Replication Using SSL”

SELECT

Section 12.7.2.1, “ANALYZE TABLE Синтаксис”
Section 12.7.2.3, “CHECKSUM TABLE Синтаксис”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.17, “CREATE TABLE Синтаксис”
Section 12.1.19, “CREATE TRIGGER Синтаксис”
Section 12.1.20, “CREATE VIEW Синтаксис”
Section 12.2.2, “DELETE Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.2.5, “INSERT Синтаксис”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Синтаксис”
Section 12.7.2.4, “OPTIMIZE TABLE Синтаксис”
Section 12.7.2.5, “REPAIR TABLE Синтаксис”
Section 12.7.5.12, “SHOW CREATE TABLE Синтаксис”
Section 12.7.5.14, “SHOW CREATE VIEW Синтаксис”
Section 12.7.5.22, “SHOW GRANTS Синтаксис”
Section 12.2.11, “UPDATE Синтаксис”
Section 18.6, “Access Control for Stored Programs and Views”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 21.2.6, “Connector/Net Connection String Options Reference”
Описание
Описание
Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”
Section 20.6, “Performance Schema General Table Characteristics”
Section 5.4.1, “Privileges Provided by MySQL”
Section E.5, “Restrictions on Views”
Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 13.10, “The MERGE Storage Engine”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”
Section 5.4, “The MySQL Access Privilege System”
Section 18.3.1, “Trigger Синтаксис”

SHOW DATABASES

Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.5.15, “SHOW DATABASES Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

SHOW VIEW

Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.5.14, “SHOW CREATE VIEW Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Section E.5, “Restrictions on Views”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”

SHUTDOWN

Section 12.7.1.3, “GRANT Синтаксис”
Section 21.9.3.65, “mysql_shutdown()”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Описание
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.10, “The Shutdown Process”

SUPER

Section 12.1.2, “ALTER EVENT Синтаксис”
Section 12.1.4, “ALTER FUNCTION Синтаксис”
Section 12.1.6, “ALTER SERVER Синтаксис”
Section 12.1.9, “ALTER VIEW Синтаксис”
Section 12.7.6.1, “BINLOG Синтаксис”
Section 12.1.11, “CREATE EVENT Синтаксис”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.16, “CREATE SERVER Синтаксис”
Section 12.1.19, “CREATE TRIGGER Синтаксис”
Section 12.1.20, “CREATE VIEW Синтаксис”
Section 12.1.22, “DROP EVENT Синтаксис”
Section 12.1.27, “DROP SERVER Синтаксис”
Section 12.1.30, “DROP TRIGGER Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.6.4, “KILL Синтаксис”
Section 12.7.1.6, “SET PASSWORD Синтаксис”
Section 12.3.6, “SET TRANSACTION Синтаксис”
Section 12.4.1.3, “SET sql_log_bin Синтаксис”
Section 12.7.4, “SET Синтаксис”
Section 12.7.5.24, “SHOW MASTER STATUS Синтаксис”
Section 12.7.5.30, “SHOW PROCESSLIST Синтаксис”
Section 12.7.5.35, “SHOW SLAVE STATUS Синтаксис”
Section 12.7.5.39, “SHOW TRIGGERS Синтаксис”
Section 12.4.2.5, “START SLAVE Синтаксис”
Section 12.4.2.6, “STOP SLAVE Синтаксис”
Section C.5.2.7, “Too many connections”
Section 21.9.3.12, “mysql_dump_debug_info()”
Section 18.6, “Access Control for Stored Programs and Views”
Section 5.5.5, “Assigning Account Passwords”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Описание
Section 11.13, “Encryption and Compression Functions”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 15.1.1, “How to Set Up Replication”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 9.7, “MySQL Server Locale Support”
Section 9.6, “MySQL Server Time Zone Support”
Section 5.4.1, “Privileges Provided by MySQL”
Section 15.1.2, “Replication Formats”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 5.2.4.2, “Setting The Binary Log Format”
Section 19.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 5.2.4, “The Binary Log”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 5.1.4, “Using System Variables”

TRIGGER

Section 12.1.19, “CREATE TRIGGER Синтаксис”
Section 12.1.30, “DROP TRIGGER Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.5.39, “SHOW TRIGGERS Синтаксис”
Section 18.6, “Access Control for Stored Programs and Views”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

UPDATE

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 12.1.19, “CREATE TRIGGER Синтаксис”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.2.5, “INSERT Синтаксис”
Section 12.7.1.4, “RENAME USER Синтаксис”
Section 12.7.1.5, “REVOKE Синтаксис”
Section 12.2.11, “UPDATE Синтаксис”
Section 18.6, “Access Control for Stored Programs and Views”
Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”
Section 20.6, “Performance Schema General Table Characteristics”
Section 20.2.3, “Performance Schema Runtime Configuration”
Section 20.7.1, “Performance Schema Setup Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 13.10, “The MERGE Storage Engine”
Section 18.3.1, “Trigger Синтаксис”

USAGE

Section 12.7.1.3, “GRANT Синтаксис”
Section 5.4.1, “Privileges Provided by MySQL”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices
   
Option Index Начало SQL Modes Index
    Поддержать сайт на родительском проекте КГБ