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 clilike this:
myslq -h some.host.com -u whoami -pMYPASSWD DBNAME
if you get in then you've follow the instructions in the mysql handbook
properlyRemember 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