hobbzilla Posted December 5, 2002 Posted December 5, 2002 Has anyone set up the admin to be on a different physical server than the database server? I seem to be experiencing problems. I've entered the IP address of the machine with the catalog & db, user/pass, db name into configure.php of the admin but I continue to receive "Unable to connect to database server!" errors. Any suggestions would be much appreciated.
mattice Posted December 5, 2002 Posted December 5, 2002 you need to allow remote connections to mysql... "Politics is the art of preventing people from taking part in affairs which properly concern them"
hobbzilla Posted December 5, 2002 Author Posted December 5, 2002 Okay, as this was my first attempt at trying to do this.. I think I figured it out.. anyone care to concur? I was attempting to connect to an outside db through a proxy server with my admin being served from 'localhost' and all I got was "Unable to connect to database server!" so I uploaded the catalog & admin to a hosted server and tried to setup with the same remote db server. This time I got an "Access denied for user: '[email protected]_server.com' (Using password: YES)" So, my take is that along with the username, the domain is appended as well. If the host that has the database only has me being able to connect to the database from "localhost" or a named database, if I try to connect from any other domain with that user/pass it will not allow me for security reasons.. Is this correct? I'm assuming I will have to plead with my host to allow this... or find a new host. Also, while i'm on this topic.. has anyone had a problem with performance when the database is on a different machine (not just a different machine in my case -- but a different host! so the request have to travel over the net! How secure is this?).
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.