I apologize if I am asking this in the wrong place, but I've hit something I cannot figure out..
I have remote drupal and civicrm databases that I want to use for multiple developers. My question concerns the civicrm.settings.php file. I can successfully connect to the remote drupal (CMS) database using the settings.php config, but my civicrm settings do not seem to be pinging the server db at all. This code (no matter which credentials/IP/DB I try) is not doing what I think it should be doing...
define( 'CIVICRM_DSN' , 'mysql://civicrm:YOUR_PASSWORD@localhost/civicrm?new_link=true');
The error:
Initialization Error
Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => simpleHandler )
[code] => -26
[message] => DB Error: insufficient permissions
[mode] => 16
[debug_info] => [nativecode=1044 ** Access denied for user 'db_user'@'12.12.12.12' to database 'db']
[type] => DB_Error
[user_info] => [nativecode=1044 ** Access denied for user 'db_user'@'12.12.12.12' to database 'db']
[to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=1044 ** Access denied for user 'db_user'@'12.12.12.12' to database 'db']"]
)
The error duplicates, which I find puzzling. Mainly, I am wondering if there is an example of somebody doing such a thing as remote setup with CiviCRM db.