Answers.Body: <p>Seems like your Civi MySQL database user does not have sufficient privileges attached to it to allow it to install Civi.</p>
  <p>This link here should provide you with the information that you need. It is quite old but should get the job done - <a href="https://forum.civicrm.org/index.php%3Ftopic=23489.0.html" rel="nofollow noreferrer">https://forum.civicrm.org/index.php%3Ftopic=23489.0.html</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-02T05:02:31.647Z
Answers.LastActivityDate: 2020-10-02T05:02:31.647Z
Answers.UserDisplayName: P Joseph
Answers.Body: <p>Check your privileges on the database, John. I suspect this may be a MySQL issue.</p>
  <p>W</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-08-30T15:54:01.530Z
Answers.LastActivityDate: 2020-08-30T15:54:01.530Z
Answers.UserDisplayName: Southside
Body: <p>I'm brand new to CiviCRM and have been asked in stall in a test site and review how it works.</p>
  <p>I have the latest WP 5.5 installed.
  I've uploaded CiviCRM via ftp to the plug ins folder.
  I went to the installer and I got the error in the screen shot below.
  Had a look at docs and I updated PHP to 7.2 and same thing happened.</p>
  <p>Can anyone tell me if this is common and what fix may be required or is there a doc you could direct me to?</p>
  <p>Many thanks,
  J</p>
  <p>THE ERROR:
  In CiviCRM Database Details</p>
  <p>IN RED:
  Can I create temporary tables in the database? = Could not create a temp table.
  Can I create lock tables in the database?      = Could not create a table in the database.
  Can I create triggers in the database?         = Could not create a database trigger.</p>
  <p>IN YELLOW
  Is the utf8mb4 charac=hter set supported =  It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. You will need the following MySQL server configuration: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true</p>
  <p><a href="https://i.sstatic.net/5vfrh.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/5vfrh.png" alt="Error" /></a></p>
  
Tags: <database><datatables>
Title: CiviCRM on WordPress wont Install Issue
ThreadText: # CiviCRM on WordPress wont Install Issue
  
  (Asked by: username_0 on 2020-08-30)
  
  I'm brand new to CiviCRM and have been asked in stall in a test site and review how it works.
  
  I have the latest WP 5.5 installed.
  I've uploaded CiviCRM via ftp to the plug ins folder.
  I went to the installer and I got the error in the screen shot below.
  Had a look at docs and I updated PHP to 7.2 and same thing happened.
  
  Can anyone tell me if this is common and what fix may be required or is there a doc you could direct me to?
  
  Many thanks,
  J
  
  THE ERROR:
  In CiviCRM Database Details
  
  IN RED:
  Can I create temporary tables in the database? = Could not create a temp table.
  Can I create lock tables in the database? = Could not create a table in the database.
  Can I create triggers in the database? = Could not create a database trigger.
  
  IN YELLOW
  Is the utf8mb4 charac=hter set supported = It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. You will need the following MySQL server configuration: innodb\_large\_prefix=true innodb\_file\_format=barracuda innodb\_file\_per\_table=true
  
  [![Error](https://i.sstatic.net/5vfrh.png)](https://i.sstatic.net/5vfrh.png)
  
  **Tags:** database, datatables
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2020-10-02. Score: 1
  
  Seems like your Civi MySQL database user does not have sufficient privileges attached to it to allow it to install Civi.
  
  This link here should provide you with the information that you need. It is quite old but should get the job done - <https://forum.civicrm.org/index.php%3Ftopic=23489.0.html>
  
  
  ---
  
  ### Answer by username_2 on 2020-08-30. Score: 0
  
  Check your privileges on the database, John. I suspect this may be a MySQL issue.
  
  W
  
  
  ---
  
  