What are the default privileges for MySQL databases?

On all MySQL databases created on our servers, the current privileges are given as default:

SELECT – Selects data in tables or columns in the database

INSERT – Inserts data into tables or columns in the database

UPDATE – Updates the data in tables or columns in the database

DELETE – Deletes rows from tables in the database

CREATE – Creates new databases, tables, or columns

DROP – Removes existing databases, tables, and views

INDEX – Creates or removes indices of existing tables

ALTER – Allows you to alter tables in the database

LOCK TABLES – Allows you to lock tables within the database

The following privileges can also be granted:

CREATE TEMPORARY TABLES – Creates temporary data tables in the database

CREATE VIEW – Creates new views of the data

CREATE ROUTINE – Creates stored routines in the database

Please raise a Support Ticket with our Customer Services team to acquire these additional privileges.