MysqlPrivileges uses ConstantsTrait

MySQL Privilege Constants.

Tags

example

foreach ( MysqlPrivileges::enums() as $privilege)
{
    echo $privilege . PHP_EOL;
}

// Check if a privilege is valid
if ( MysqlPrivileges::includes('SELECT') )
{
    echo 'Valid MySQL privilege.' ;
}

link

MySQL Official Privilege Reference

Table of Contents

Constants

ALL_PRIVILEGES  = 'ALL PRIVILEGES'

ALTER  = 'ALTER'

ALTER_ROUTINE  = 'ALTER ROUTINE'

CREATE  = 'CREATE'

CREATE_ROUTINE  = 'CREATE ROUTINE'

CREATE_TEMPORARY_TABLES  = 'CREATE TEMPORARY TABLES'

CREATE_USER  = 'CREATE USER'

CREATE_VIEW  = 'CREATE VIEW'

DELETE  = 'DELETE'

DROP  = 'DROP'

EVENT  = 'EVENT'

EXECUTE  = 'EXECUTE'

FILE  = 'FILE'

GRANT_OPTION  = 'GRANT OPTION'

INDEX  = 'INDEX'

INSERT  = 'INSERT'

LOCK_TABLES  = 'LOCK TABLES'

PROCESS  = 'PROCESS'

REFERENCES  = 'REFERENCES'

RELOAD  = 'RELOAD'

REPLICATION_CLIENT  = 'REPLICATION CLIENT'

REPLICATION_SLAVE  = 'REPLICATION SLAVE'

SELECT  = 'SELECT'

SHOW_DATABASES  = 'SHOW DATABASES'

SHOW_VIEW  = 'SHOW VIEW'

SHUTDOWN  = 'SHUTDOWN'

SUPER  = 'SUPER'

TRIGGER  = 'TRIGGER'

UPDATE  = 'UPDATE'

USAGE  = 'USAGE'

DESCRIPTIONS  = [self::ALL_PRIVILEGES => 'Grants all available privileges.', self::SELECT => 'Allows reading data using SELECT.', self::INSERT => 'Allows inserting data into tables.', self::UPDATE => 'Allows updating existing rows.', self::DELETE => 'Allows deleting rows from tables.', self::CREATE => 'Allows creation of new databases and tables.', self::DROP => 'Allows deletion of databases and tables.', self::ALTER => 'Allows modifying table structure.', self::INDEX => 'Allows creating and dropping indexes.', self::TRIGGER => 'Allows creating and dropping triggers.', self::REFERENCES => 'Allows defining foreign keys.', self::LOCK_TABLES => 'Allows locking tables for access control.', self::CREATE_TEMPORARY_TABLES => 'Allows creating temporary tables.', self::CREATE_VIEW => 'Allows creating views.', self::SHOW_VIEW => 'Allows viewing definitions of views.', self::CREATE_ROUTINE => 'Allows creating stored procedures and functions.', self::ALTER_ROUTINE => 'Allows modifying or dropping routines.', self::EXECUTE => 'Allows executing stored routines.', self::EVENT => 'Allows creating, altering, dropping events.', self::FILE => 'Allows reading/writing files on the server.', self::PROCESS => 'Allows viewing threads from all users.', self::RELOAD => 'Allows reloading server configuration.', self::SHUTDOWN => 'Allows shutting down the server.', self::SUPER => 'Grants various powerful administrative privileges.', self::SHOW_DATABASES => 'Allows seeing all databases.', self::CREATE_USER => 'Allows creating, renaming and dropping users.', self::GRANT_OPTION => 'Allows granting privileges to other users.', self::REPLICATION_CLIENT => 'Allows querying replication status.', self::REPLICATION_SLAVE => 'Allows replication slaves to connect.', self::USAGE => 'Minimal privilege: allows connection only.']

Human-readable description for each MySQL privilege.

Methods

allDescriptions()  : array<string, string>

Get all privileges with their description.

describe()  : string|null

Get a human-readable description for a given privilege.