What MySQL privileges are supported by cPanel?

Question

MySQL/MariaDB offer various levels of database privileges, ranging from "Database" level privileges to "Global" privileges. Which ones does cPanel support?

Answer

By default, cPanel only offers support for standard privileges which do not require "SUPER" privileges or allow for global modifications.

The current list of supported privileges are as follows:

ALTER

ALTER ROUTINE

CREATE

CREATE ROUTINE

CREATE TEMPORARY TABLES

CREATE VIEW

DELETE

DROP

EVENT

EXECUTE

INDEX

INSERT

LOCK TABLES

REFERENCES

SELECT

SHOW VIEW

TRIGGER

UPDATE

When selecting to grant "All privileges", these are the included privileges given to the database via the cPanel interface.