Database Reference
In-Depth Information
Privilege
Description
INDEX
Grantsthe use of the
CREATE INDEX
and
DROP INDEX
statements.
INSERT
Permitsthe use of
INSERT
statements. It's required toexecute
ANALYZE TABLE
,
OPTIMIZE TABLE
, and
REPAIR TABLE
statements.
LOCK
TABLES
Allows theuse of
LOCK TABLES
statements for tables for which the user has
SELECT
privileges.
PROCESS
Allowsthe use of the
SHOW PROCESSLIST
and
SHOW ENGINE
statements.
RELOAD
Allowsthe
FLUSH
statement to be issued.
REPLICATION
CLIENT
Allowsthe user to query master and slave servers for status information, the
SHOW
MASTER STATUS
and
SHOW SLAVE STATUS
statements, as well as the
SHOW BINARY
LOGS
statement.
REPLICATION
SLAVE
Requiredfor replication slave servers, this allows binary log events to be read from the
master server.
SELECT
Allowsthe use of the
SELECT
statement.
SHOW
DATABASES
Permitsthe use of the
SHOW DATABASES
statement for all databases, not just the ones
for which the user has privileges.
SHOW VIEW Allowsthe use of the
SHOW CREATE VIEW
statement.
SHUTDOWN Allowsthe use of the
shutdown
optionwith the
mysqladmin
utility.
SUPER
Grantsuse of
CHANGE MASTER TO
,
KILL
,
PURGE BINARY LOGS
, and
SET GLOBAL
statements, and the
debug
option with the command-line utility
mysqladmin
.
TRIGGER
Thisprivilege allows the user account the ability to create and drop triggers, using the
CREATE TRIGGER
and the
DROP TRIGGER
statements.
UPDATE
Allowsthe
UPDATE
statement to be used.
USAGE
Includedto create a user without privileges, or to modify an existing one without affect-
ing the existingprivileges.
