MySQL user privileges on shared servers

This article discusses MySQL privileges available on shared hosting accounts.

MySQL user privileges

For security and performance reasons, A2 Hosting does not allow shared hosting accounts to have MySQL superuser access. Instead, if your account is on a shared 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.

Get MySQL Hosting

Article Details

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.