well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver make sure the mysql client is installed and try logging into the db from the cli....like this:
myslq -h some.host.com -u whoami -pMYPASSWD DBNAME if you get in then you've follow the instructions in the mysql handbook properly....Remember to use mysqladmin to reload the new grants before you try the remote connection...or you'll be left with some rather frustrating troubleshooting and quite probably the jitters from that extra few doses of coffee... cheers, m! [EMAIL PROTECTED] wrote: > Can someone pls advise me on how to make a website running in an apache > webserver on a Linux box connect to a remote mySQL database on a separate > Sun box? > > Thank you. > > ------------------------------------------------------------------------ > ----------------------------------------- (on foxtrot) > > Privileged/Confidential Information may be contained in this message. If you are not >the addressee indicated in this message (or responsible for delivery of the message >to such person), you may not copy or deliver this message to anyone. In such case, >you should destroy this message and kindly notify the sender by reply email. Please >advise immediately if you or your employer does not consent to email for messages of >this kind. Opinions, conclusions and other information in this message that do not >relate to the official business of the WPP Group shall be understood as neither given >nor endorsed by it. > > --------------------------------------------------------- > > ------------------------------------------------------------------------ > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php