I am installing Civi on localhhost. I want to set up a database separate to Wordpress. I am using these credentials: mysql://root:HIDDEN@localhost/cividata. The database username is root, without a password. I get the same issue as described here; Can't connect to separate database. Would it be possible for someone to tell me what the correct syntax should be? Instead of HIDDEN should I use '' Thanks.
My problem turned out to be special characters in the password. Once I changed the password the connection worked fine. To connect to the database, I just changed the path in this line in civicrm-settings.php file to:
The answer to the question about the syntax needed on install when wanting a separate database is as follows. I struggled with this myself today, which was on a Drupal 7 site.
where of course example_dbuser is the user name, password is the password without special characters and example_dbname is the separate civicrm database name.