MySQL Forums
Forum List  »  PHP

Connect PHP to a remote MySQL Database
Posted by: Steve Carlsen
Date: May 03, 2006 06:37PM

I have installed PHP 4.x with MySQL 4.1.x.
I am using SugarCRM for customer management. Sugar CRM is a resource hog, so I have had to put a development machine together.

I have the web site ( sugar CRM ) installed on one box and I have the databases on a completely seperate box ( because there is more processing power available ).
I can't have two sugar websites running on the same machine or I run out of memory ( and this is on a machine with 2Gb's of RAM).

I need to connect to the machine 1 (website machine) to machine2 (database machine). The only response I can get from the webserver is:
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in D:\devsugar\include\database\PearDatabase.php on line 591 Unable to select database: Access denied for user 'ODBC'@'localhost'
(using password: NO)

I know this is a very generic error, that basically tells me that the website can't get to the database. I have added a database specific user so the user should be able to connect.

WHAT AM I MISSING???
I am pulling my hair out.

Options: ReplyQuote


Subject
Written By
Posted
Connect PHP to a remote MySQL Database
May 03, 2006 06:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.