Answers.Body: <p>It looks like the mysql user you use doesn't have enough permissions on the database (or invalid database/password?)</p>
  
  <p>This page lists all the privileges that civicrm mysql account needs:</p>
  
  <p><a href="https://docs.civicrm.org/sysadmin/en/latest/requirements/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/requirements/</a></p>
  
  <pre><code>  GRANT
    SELECT,
    INSERT,
    UPDATE,
    DELETE,
    CREATE,
    DROP,
    INDEX,
    ALTER,
    CREATE TEMPORARY TABLES,
    LOCK TABLES,
    TRIGGER,
    CREATE ROUTINE,
    ALTER ROUTINE,
    REFERENCES,
    CREATE VIEW,
    SHOW VIEW
  ON civicrm.*
  TO 'civicrm_user'@'localhost'
  IDENTIFIED BY 'realpasswordhere';
  </code></pre>
  
  <p>you would obviously need to adjust with the database and user account you have</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-20T10:42:24.977Z
Answers.LastActivityDate: 2019-08-20T10:42:24.977Z
Answers.UserDisplayName: Xavier
Body: <p>Installation problem of civicrm on wordpress : formulaire d'installation</p>
  
  <p>Check the prerequisites and install Civicrm
  Reverification of the prerequisites.</p>
  
  <p>Is auto_increment_increment set to 1 Unable to query database server variables.</p>
  
  <p>Is the database name valid? okay</p>
  
  <p>Does the value of MySQL stored procedures (thread_stack) have the required minimum value (192k) Unable to get information about stored procedures in the database.</p>
  
  <p>THANKS FOR YOUR HELP</p>
  
  <hr>
  
  <p>I still have the problem.</p>
  
  <p>Apache 2.4.25 x86 - PHP 7.1.3 x86 Port: 80
    MySQL 5.7.17 x86 Port: 3306
  WordPress 5.2.2
  CiviCRM-5.16.2-wordpress</p>
  
  <p>On my database.
  Privileges are on GRANT in this asso_organization database.</p>
  
  <hr>
  
  <p>Mysql server: localhost
  Username Mysql = root
  Password = ''
  Database = asso_organisation</p>
  
  <p>When I press: check the prerequisites and install CiviCrm:
  He created me the database "asso_organisation" but, he always displays two error messages:
  Is auto_increment_increment set to 1 /// Unable to query database server variables.
  Does the value of MySQL stored procedures (thread_stack) have the required minimum value (192k)? // Unable to get information about the stored procedures of the database.
  Thank you for helping me</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-19T09:19:20.383Z
Comments.Text: Can you check the username and password of mysql user and has permission to run some basic commands on the database
Comments.UserDisplayName: Pradeep Nayak
Tags: <wordpress><civicontribute>
Title: Installation problem of civicrm on wordpress
ThreadText: # Installation problem of civicrm on wordpress
  
  (Asked by: username_0 on 2019-08-19)
  
  Installation problem of civicrm on wordpress : formulaire d'installation
  
  Check the prerequisites and install Civicrm
  Reverification of the prerequisites.
  
  Is auto\_increment\_increment set to 1 Unable to query database server variables.
  
  Is the database name valid? okay
  
  Does the value of MySQL stored procedures (thread\_stack) have the required minimum value (192k) Unable to get information about stored procedures in the database.
  
  THANKS FOR YOUR HELP
  
  ---
  
  I still have the problem.
  
  Apache 2.4.25 x86 - PHP 7.1.3 x86 Port: 80
    MySQL 5.7.17 x86 Port: 3306
  WordPress 5.2.2
  CiviCRM-5.16.2-wordpress
  
  On my database.
  Privileges are on GRANT in this asso\_organization database.
  
  ---
  
  Mysql server: localhost
  Username Mysql = root
  Password = ''
  Database = asso\_organisation
  
  When I press: check the prerequisites and install CiviCrm:
  He created me the database "asso\_organisation" but, he always displays two error messages:
  Is auto\_increment\_increment set to 1 /// Unable to query database server variables.
  Does the value of MySQL stored procedures (thread\_stack) have the required minimum value (192k)? // Unable to get information about the stored procedures of the database.
  Thank you for helping me
  
  **Tags:** wordpress, civicontribute
  
  > **Comments:**
  > **username_1**: Can you check the username and password of mysql user and has permission to run some basic commands on the database  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-08-20. Score: 3
  
  It looks like the mysql user you use doesn't have enough permissions on the database (or invalid database/password?)
  This page lists all the privileges that civicrm mysql account needs:
  https://docs.civicrm.org/sysadmin/en/latest/requirements/
    GRANT
    SELECT,
    INSERT,
    UPDATE,
    DELETE,
    CREATE,
    DROP,
    INDEX,
    ALTER,
    CREATE TEMPORARY TABLES,
    LOCK TABLES,
    TRIGGER,
    CREATE ROUTINE,
    ALTER ROUTINE,
    REFERENCES,
    CREATE VIEW,
    SHOW VIEW
  ON civicrm.*
  TO 'civicrm_user'@'localhost'
  IDENTIFIED BY 'realpasswordhere';
  
  you would obviously need to adjust with the database and user account you have
  
  
  ---
  
  