Answers.Body: <p>Is it possible your civicrm_settings.php file is not writable, or is duplicated? If you run php_info() does it confirm that you're running MySQL 5.7? What is your OS?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-12T14:05:23.433Z
Answers.LastActivityDate: 2019-08-12T14:05:23.433Z
Answers.UserDisplayName: Lesley Evensen
Answers.Body: <p>UPDATE: It looks like at the present time you will need to make a small hack to get the installer to be happy. The "does the server exist check" does NOT use the username/password and merely tries to connect as anonymous (<a href="https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1038" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1038</a>). On azure this returns an error 9002, as opposed to the usual 1045 which gets skipped by the next line.</p>
  
  <p>So you should be able to temporarily change that line to</p>
  
  <p><code>$conn = $this-&gt;connect($server, 'username@server', 'your password');</code></p>
  
  <p>and then after install you can change it back. I don't have an azure database to test if that is sufficient, but just doing a command line test it returns the usual error 1045 so should work.</p>
  
  <p>See also <a href="https://civicrm.stackexchange.com/questions/31794/civicrm-on-azure-not-finding-the-server?noredirect=1&amp;lq=1">CiviCRM on Azure Not Finding the Server</a></p>
  
  <hr>
  
  <p>Based on your screenshot it looks like you have a "control character" as the first character of your server name, which usually happens when you copy and paste from a website page. i.e. a character that isn't actually a letter but might be a tab or non-ascii character.</p>
  
  <p>In any case the error says it can't find mysql on that server, so check that the server name is correct.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-13T22:38:37.957Z
Answers.Text: Well, I could understand that, if it wasn't because it's all copied from VIM from the wp-config.php file, and the Wordpress site *is working*.
Answers.UserDisplayName: Jesper Angelo LI
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-13T22:39:01.813Z
Answers.Text: Also, the lines (in green) states
      Are the access credentials correct?    OK
      MySQL version at least 5.1      OK (MySQL 5.6.39.0)
      Is auto_increment_increment set to 1    OK
      Is the provided database name valid?   OK
      Does MySQL thread_stack meet minimum (192k) OK
      Can I access/create the database?    OK (Database 'xxxxx' exists)
      Can I access/create InnoDB tables in the database? OK
      Can I create temporary tables in the database?  OK
      Can I create lock tables in the database?   OK
      Can I create triggers in the database?   OK
Answers.UserDisplayName: Jesper Angelo LI
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-13T22:39:18.280Z
Answers.Text: So it's connecting, it seems like.
  
  Even the error "Can't find the a MySQL server on ..." seems a little off, given that it states the version is MySQL 5.6.39.0
Answers.UserDisplayName: Jesper Angelo LI
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-13T22:39:50.740Z
Answers.Text: Oh shoot, so sorry, forgot comments dont format...! Argh
Answers.UserDisplayName: Jesper Angelo LI
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-13T22:44:07.113Z
Answers.Text: +1 for vim (he he). But I don't have any more insight to the problem other than the servername.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-13T23:04:18.973Z
Answers.Text: Thanks for giving it a try @Demerit  !
Answers.UserDisplayName: Jesper Angelo LI
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-09-22T02:36:58.267Z
Answers.Text: https://lab.civicrm.org/dev/core/issues/1206
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-13T21:04:27.123Z
Answers.LastActivityDate: 2019-08-23T00:08:07.300Z
Answers.LastEditDate: 2019-08-23T00:08:07.300Z
Answers.UserDisplayName: Demerit
Body: <p>trying to install CiviCRM with Wordpress and I get the red DB error BUT all the line items are green.</p>
  
  <p>Any suggestions?</p>
  
  <p>Thanks!</p>
  
  <pre><code>WP: 4.9.10
  CiviCRM: 4.7.30 Wordpress
  Mysql: 5.7 on Azure
  </code></pre>
  
  <p><em>Added comment:</em></p>
  
  <p>I also ran this:</p>
  
  <pre><code>&lt;?php
  echo "* SQL CONNECT TEST **";
  include('./config.php');
  // print_r(get_defined_constants(true));
  #phpinfo();
  $dbcnx = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
  if (!$dbcnx)
  {
            print ("&lt;hr /&gt;&lt;p&gt;Param(s): " . DB_HOST ." / ". DB_USER ." / ". DB_PASSWORD ." / ". DB_NAME . "&lt;/p&gt;\n");
            die ("&lt;hr /&gt;&lt;p&gt;Error:" . mysqli_connect_errno() . "&lt;/p&gt;\n");
  }
  echo "&lt;p&gt;Connected to the database server!&lt;/p&gt;\n";
  echo "&lt;/p&gt;\n";
  echo "&lt;p&gt;End of script!&lt;/p&gt;";
  ?&gt;
  </code></pre>
  
  <p>Came out clean, connected and all (config.php is a copy of the Wordpress config file)</p>
  
  <p>So I checked to see if somehow CiviCRM was using mysql_connect() instead of mysql<em>i</em>_connect(), but it's not.</p>
  
  <p>Really at a loss here :-|</p>
  
  <p><a href="https://i.sstatic.net/nDkY6.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/nDkY6.png" alt="All green, but still red..."></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-14T09:26:24.353Z
Comments.Text: Do you use a port other than the default one (3306)? There is an issue about that in https://lab.civicrm.org/dev/core/issues/46. Have you tried an up to date version of CiviCRM? 4.7.30 is well out of security updates.
Comments.UserDisplayName: Thomas Schüttler
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-14T20:33:27.887Z
Comments.Text: I will try a new version today. And no everything is default, which is why I'm baffled ( not my first CC install ).
Comments.UserDisplayName: Jesper Angelo LI
Tags: <wordpress><error><database><install>
Title: Your database settings don't appear to be correct. All green, but still error!
ThreadText: # Your database settings don't appear to be correct. All green, but still error!
  
  (Asked by: username_0 on 2019-03-13)
  
  trying to install CiviCRM with Wordpress and I get the red DB error BUT all the line items are green.
  
  Any suggestions?
  
  Thanks!
  
  ```
  WP: 4.9.10
  CiviCRM: 4.7.30 Wordpress
  Mysql: 5.7 on Azure
  
  ```
  
  *Added comment:*
  
  I also ran this:
  
  ```
  <?php
  echo "* SQL CONNECT TEST **";
  include('./config.php');
  // print_r(get_defined_constants(true));
  #phpinfo();
  $dbcnx = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
  if (!$dbcnx)
  {
            print ("<hr /><p>Param(s): " . DB_HOST ." / ". DB_USER ." / ". DB_PASSWORD ." / ". DB_NAME . "</p>\n");
            die ("<hr /><p>Error:" . mysqli_connect_errno() . "</p>\n");
  }
  echo "<p>Connected to the database server!</p>\n";
  echo "</p>\n";
  echo "<p>End of script!</p>";
  ?>
  
  ```
  
  Came out clean, connected and all (config.php is a copy of the Wordpress config file)
  
  So I checked to see if somehow CiviCRM was using mysql\_connect() instead of mysql*i*\_connect(), but it's not.
  
  Really at a loss here :-|
  
  [![All green, but still red...](https://i.sstatic.net/nDkY6.png)](https://i.sstatic.net/nDkY6.png)
  
  **Tags:** wordpress, error, database, install
  
  > **Comments:**
  > **username_1**: Do you use a port other than the default one (3306)? There is an issue about that in https://lab.civicrm.org/dev/core/issues/46. Have you tried an up to date version of CiviCRM? 4.7.30 is well out of security updates.  
  > **username_0**: I will try a new version today. And no everything is default, which is why I'm baffled ( not my first CC install ).  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2019-08-12. Score: 0
  
  Is it possible your civicrm\_settings.php file is not writable, or is duplicated? If you run php\_info() does it confirm that you're running MySQL 5.7? What is your OS?
  
  
  ---
  
  ### Answer by username_3 on 2019-03-13. Score: 0
  
  UPDATE: It looks like at the present time you will need to make a small hack to get the installer to be happy. The "does the server exist check" does NOT use the username/password and merely tries to connect as anonymous (<https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1038>). On azure this returns an error 9002, as opposed to the usual 1045 which gets skipped by the next line.
  
  So you should be able to temporarily change that line to
  
  `$conn = $this->connect($server, 'username@server', 'your password');`
  
  and then after install you can change it back. I don't have an azure database to test if that is sufficient, but just doing a command line test it returns the usual error 1045 so should work.
  
  See also [CiviCRM on Azure Not Finding the Server](https://civicrm.stackexchange.com/questions/31794/civicrm-on-azure-not-finding-the-server?noredirect=1&lq=1)
  
  ---
  
  Based on your screenshot it looks like you have a "control character" as the first character of your server name, which usually happens when you copy and paste from a website page. i.e. a character that isn't actually a letter but might be a tab or non-ascii character.
  
  In any case the error says it can't find mysql on that server, so check that the server name is correct.
  
  > **Comments:**
  > **username_0**: Well, I could understand that, if it wasn't because it's all copied from VIM from the wp-config.php file, and the Wordpress site *is working*.  
  > **username_0**: Also, the lines (in green) states     Are the access credentials correct?    OK     MySQL version at least 5.1      OK (MySQL 5.6.39.0)     Is auto_increment_increment set to 1    OK     Is the provided database name valid?   OK     Does MySQL thread_stack meet minimum (192k) OK     Can I access/create the database?    OK (Database 'xxxxx' exists)     Can I access/create InnoDB tables in the database? OK     Can I create temporary tables in the database?  OK     Can I create lock tables in the database?   OK     Can I create triggers in the database?   OK  
  > **username_0**: So it's connecting, it seems like.  Even the error "Can't find the a MySQL server on ..." seems a little off, given that it states the version is MySQL 5.6.39.0  
  > **username_0**: Oh shoot, so sorry, forgot comments dont format...! Argh  
  > **username_3**: +1 for vim (he he). But I don't have any more insight to the problem other than the servername.  
  > **username_0**: Thanks for giving it a try @username_3  !  
  > **username_3**: https://lab.civicrm.org/dev/core/issues/1206  
  
  ---
  
  