Answers.Body: <p>No, you don't need to have root access to the database. However, the database user does need to have the following permissions:</p>
  
  <pre><code>SELECT,INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE
  </code></pre>
  
  <p>It sounds like the database user doesn't currently have the required permissions to access the database.  You should check with your website host to see if it is possible to get these permissions, but not all shared hosting packages will allow this level of access to the database.  If this is not possible with your hosting package you may need to look for a hosting package that does meet these requirements.</p>
  
  <p>See the wiki for more details: <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements" rel="nofollow">CiviCRM MySQL Permission Requirements</a></p>
  
  <p>And this page for the general requirements: <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades" rel="nofollow">Installation and Upgrades</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-17T19:56:26.687Z
Answers.LastActivityDate: 2016-10-17T19:56:26.687Z
Answers.UserDisplayName: William Mortada
Body: <p>After installing your plug in, I looked at the CiviCRM installer page and was shown an error which said "unable to create database triggers".  I have shared hosting.  Is it possible to still use this plug in?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-10-18T00:38:36.247Z
Comments.Text: Also see *[Installation Issue - Database Triggers](http://civicrm.stackexchange.com/questions/15199)* and *[Could not create a database trigger on AWS RDS](http://civicrm.stackexchange.com/questions/11199)*. Please remember to search for older questions before asking, and if they or other outside research are not adequate, to explain why.
Comments.UserDisplayName: choster
Tags: <database><installation><mysql>
Title: Do I need root access to my database to use CiviCRM?
ThreadText: # Do I need root access to my database to use CiviCRM?
  
  (Asked by: username_0 on 2016-10-17)
  
  After installing your plug in, I looked at the CiviCRM installer page and was shown an error which said "unable to create database triggers". I have shared hosting. Is it possible to still use this plug in?
  
  **Tags:** database, installation, mysql
  
  > **Comments:**
  > **username_1**: Also see *[Installation Issue - Database Triggers](http://civicrm.stackexchange.com/questions/15199)* and *[Could not create a database trigger on AWS RDS](http://civicrm.stackexchange.com/questions/11199)*. Please remember to search for older questions before asking, and if they or other outside research are not adequate, to explain why.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-10-17. Score: 2 | Accepted answer
  
  No, you don't need to have root access to the database. However, the database user does need to have the following permissions:
  
  ```
  SELECT,INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE
  
  ```
  
  It sounds like the database user doesn't currently have the required permissions to access the database. You should check with your website host to see if it is possible to get these permissions, but not all shared hosting packages will allow this level of access to the database. If this is not possible with your hosting package you may need to look for a hosting package that does meet these requirements.
  
  See the wiki for more details: [CiviCRM MySQL Permission Requirements](https://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements)
  
  And this page for the general requirements: [Installation and Upgrades](https://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades)
  
  
  ---
  
  