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.
Article ID: 25
Created On: Mon, Mar 2, 2015 at 5:09 PM
Last Updated On: Thu, Apr 23, 2015 at 10:38 AM
Online URL: https://www.heartinternet.uk/support/article/what-are-the-default-privileges-for-mysql-databases.html