Answers.Body: <p>CiviCRM doesn't like database user passwords with special characters - especially &quot;#&quot;. Change password.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-13T12:00:18.447Z
Answers.LastActivityDate: 2024-02-13T12:00:18.447Z
Answers.UserDisplayName: Jakub Kulesza
Body: <p>Trying a new install of CiviCRM 5.3.9 using a separate Wordpress database. Wordpress, MySQL and PHP are confirmed required versions. Path is definitely correct using mysql://USER:PASSWORD@localhost:3306/DB   but throws errors when I click Apply.</p>
  <ul>
  <li>Error     Database    CiviCRM InnoDB support  Could not determine if MySQL has InnoDB support. Assuming none.</li>
  <li>Error     Database    CiviCRM MySQL AutoIncrementIncrement    Could not connect to database</li>
  <li>Error     Database    CiviCRM MySQL Lock Tables   Could not connect to database</li>
  <li>Error     Database    CiviCRM MySQL Temp Tables   Could not connect to database</li>
  <li>Error     Database    CiviCRM MySQL Trigger   Could not connect to database</li>
  <li>Error     Database    CiviCRM MySQL connection    Access denied for user ''@'localhost' (using password: NO)</li>
  <li>Error     Database    CiviCRM MySQL utf8mb4 Support   Could not connect to database</li>
  <li>Error     Database    CiviCRM Mysql thread stack  Could not connect to database</li>
  <li>Error     Database    db.database     The property &quot;db.database&quot; is not well-formed.</li>
  <li>Error     Database    db.username     The property &quot;db.username&quot; is not well-formed.</li>
  <li>Warning   Database    CiviCRM MySQL Version   Cannot determine the version of MySQL installed. Please ensure at least version 5.6.5 is installed.</li>
  <li>Warning   Database    db.password     The property &quot;db.password&quot; is blank. This may be correct in some controlled environments; it could also be a mistake or a symptom of an insecure configuration.</li>
  </ul>
  <p>The password is entered correctly in the path. I had a previous install that used exactly the same path to a separate database that worked fine for some time, then stopped working. Is there something wrong with the CiviCRM install? Can anyone suggest why the connection is failing?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-13T04:18:35.750Z
Comments.Text: if you don't get a quick and satisfactory answer here you could also try https://chat.civicrm.org/civicrm/channels/wordpress
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-13T10:10:50.070Z
Comments.Text: Is this a hosted environment?  If so, talk to hosting support.
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-14T19:07:40.893Z
Comments.Text: It turns out CiviCRM doesn't like database user passwords with special characters. Once I removed those characters from the password, the connection worked fine. I have not seen that information in any CiviCRM documentation. I have the same special characters in my Wordpress/MySQL database connection and it works fine.
Comments.UserDisplayName: Scarlett
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-09-03T16:30:18.820Z
Comments.Text: @Scarlett thanks for the update. it would be helpful to others if you could post your comment as an answer to this question.
Comments.UserDisplayName: William Mortada
Tags: <wordpress><database><installation>
Title: Can't connect to separate database
ThreadText: # Can't connect to separate database
  
  (Asked by: username_0 on 2021-07-13)
  
  Trying a new install of CiviCRM 5.3.9 using a separate Wordpress database. Wordpress, MySQL and PHP are confirmed required versions. Path is definitely correct using mysql://USER:PASSWORD@localhost:3306/DB but throws errors when I click Apply.
  
  * Error Database CiviCRM InnoDB support Could not determine if MySQL has InnoDB support. Assuming none.
  * Error Database CiviCRM MySQL AutoIncrementIncrement Could not connect to database
  * Error Database CiviCRM MySQL Lock Tables Could not connect to database
  * Error Database CiviCRM MySQL Temp Tables Could not connect to database
  * Error Database CiviCRM MySQL Trigger Could not connect to database
  * Error Database CiviCRM MySQL connection Access denied for user ''@'localhost' (using password: NO)
  * Error Database CiviCRM MySQL utf8mb4 Support Could not connect to database
  * Error Database CiviCRM Mysql thread stack Could not connect to database
  * Error Database db.database The property "db.database" is not well-formed.
  * Error Database db.username The property "db.username" is not well-formed.
  * Warning Database CiviCRM MySQL Version Cannot determine the version of MySQL installed. Please ensure at least version 5.6.5 is installed.
  * Warning Database db.password The property "db.password" is blank. This may be correct in some controlled environments; it could also be a mistake or a symptom of an insecure configuration.
  
  The password is entered correctly in the path. I had a previous install that used exactly the same path to a separate database that worked fine for some time, then stopped working. Is there something wrong with the CiviCRM install? Can anyone suggest why the connection is failing?
  
  **Tags:** wordpress, database, installation
  
  > **Comments:**
  > **username_1**: if you don't get a quick and satisfactory answer here you could also try https://chat.civicrm.org/civicrm/channels/wordpress  
  > **username_2**: Is this a hosted environment?  If so, talk to hosting support.  
  > **username_0**: It turns out CiviCRM doesn't like database user passwords with special characters. Once I removed those characters from the password, the connection worked fine. I have not seen that information in any CiviCRM documentation. I have the same special characters in my Wordpress/MySQL database connection and it works fine.  
  > **username_3**: @username_0 thanks for the update. it would be helpful to others if you could post your comment as an answer to this question.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2024-02-13. Score: 1
  
  CiviCRM doesn't like database user passwords with special characters - especially "#". Change password.
  
  
  ---
  
  