MySQL user privileges on shared servers

Get details on various MySQL privileges available on shared hosting accounts with this guide which includes links to articles on related topics and more.

Suggest Edits

This article discusses MySQL privileges available on shared and reseller hosting accounts.

MySQL user privileges

For security and performance reasons, we do not allow shared or reseller hosting accounts to have MySQL superuser access. Instead, if your account is on a shared or reseller server, you are granted the following set of MySQL privileges:

ALTER
CREATE
CREATE ROUTINE
CREATE TEMPORARY TABLES
CREATE VIEW
DELETE
DROP
EXECUTE
INDEX
INSERT
LOCK TABLES
REFERENCES
SELECT
SHOW VIEW
TRIGGER
UPDATE

MySQL Event Scheduler

The set of user privileges listed above does not allow you to use the MySQL Event Scheduler on a shared server. In addition to the possible security implications of granting additional privileges, running the Event Scheduler in a shared environment could potentially cause high resource usage and affect other accounts.

However, the MySQL Event Scheduler can be enabled for managed VPS and managed dedicated servers. Similarly, unmanaged VPS users can configure the MySQL Event Scheduler on their systems.

More Information

For more information about MySQL privileges, please visit http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html.

Managing MySQL databases, users, and tables from the command line

Updated 3 days ago