Internet-Webhosting Live Chat
Knowledgebase
MySQL User Privileges on Shared Servers
Posted by M. Nadzri on 07 October 2016 04:34 PM

MySQL User Privileges

For security and performance reasons, we 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 Virtual Private Server (VPS) and Dedicated Servers as Users are free to configure the MySQL Event Scheduler on their Systems.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Internet-Webhosting - Sales & Support System