Answers.Body: <ul>
  <li>Connect to <a href="https://docs.bitnami.com/aws/faq/get-started/connect-ssh/" rel="nofollow noreferrer">Bitnami using SSH</a>.</li>
  <li>Find <code>civicrm.settings.php</code> with <code>find . -name civicrm.settings.php</code>.  You can probably speed things along by first navigating to <code>apps/civicrm/htdocs</code>.</li>
  <li>In the file, look for the line that defines <code>CIVICRM_DSN</code>, which can be interpreted as follows:</li>
  </ul>
  
  <pre><code>    define('CIVICRM_DSN', 'mysql://user:password@host/database?new_link=true');
  </code></pre>
  
  <p>According to the <a href="https://bitnami.com/stack/civicrm/README.txt" rel="nofollow noreferrer">Bitnami CiviCRM docs</a> the port is 3006.  I assume that's correct and not a typo for "3306".</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-28T08:33:02.853Z
Answers.Text: I figured out the credentials using bitnami docs. The mySQL doc says the default username is root, and the password is the Admin Password (Temporary) that we see in google cloud console where Admin URL, site address are listed. I did SSH from there and able to connect with mysql using root and temp password. The port is actually 3306, i checked the docs. Problem is what to enter in Server/Host in Tableau ? Second, in CIVICRM_DSN, what is username and password.
Answers.UserDisplayName: Ajeet
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-28T03:57:15.780Z
Answers.LastActivityDate: 2019-02-28T03:57:15.780Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I have installed civicrm bitnami stack on google cloud. </p>
  
  <p>I need to connect sql database with tableau for data visualisation. How can i get the server, port, username and password for this connection.</p>
  
Tags: <civicrm.settings.php><mysql-5.7>
Title: sql username and password
ThreadText: # sql username and password
  
  (Asked by: username_0 on 2019-02-26)
  
  I have installed civicrm bitnami stack on google cloud.
  
  I need to connect sql database with tableau for data visualisation. How can i get the server, port, username and password for this connection.
  
  **Tags:** civicrm.settings.php, mysql-5.7
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-02-28. Score: 1
  
  * Connect to [Bitnami using SSH](https://docs.bitnami.com/aws/faq/get-started/connect-ssh/).
  * Find `civicrm.settings.php` with `find . -name civicrm.settings.php`. You can probably speed things along by first navigating to `apps/civicrm/htdocs`.
  * In the file, look for the line that defines `CIVICRM_DSN`, which can be interpreted as follows:
  
  ```
      define('CIVICRM_DSN', 'mysql://user:password@host/database?new_link=true');
  
  ```
  
  According to the [Bitnami CiviCRM docs](https://bitnami.com/stack/civicrm/README.txt) the port is 3006. I assume that's correct and not a typo for "3306".
  
  > **Comments:**
  > **username_0**: I figured out the credentials using bitnami docs. The mySQL doc says the default username is root, and the password is the Admin Password (Temporary) that we see in google cloud console where Admin URL, site address are listed. I did SSH from there and able to connect with mysql using root and temp password. The port is actually 3306, i checked the docs. Problem is what to enter in Server/Host in Tableau ? Second, in CIVICRM_DSN, what is username and password.  
  
  ---
  
  