Re: update: How do I connect to a mysql server on another server?

Hi Trond You can use IP address or hostname, depending on which is more suitable for you. You will need to make sure that the hosts table in the 'mysql' database allows access from wherever you are trying to connect from. I hope this gives you an idea. Have a check of the MySQL manual about permissions, it is all covered there... Regards Paul ----- Original Message ----- From: "Trond Erling Hundal" <webmaster@port-industry.com> To: "PHP-DB-LIST" <php-db@lists.php.net> Sent: Monday, October 16, 2000 3:42 PM Subject: [PHP-DB] update: How do I connect to a mysql server on another server? > is it enough to set the other site`s ip address as the host in the > "connection command"????? > Or can I use the direct address? (www.address.com) ? > > Hi there... > We recently made a deal with another site that we would supply their site > with news that are put out on our site. > The other site has supplied me with the required username, password etc for > mysql, and all I need to do now is to update our insertion scripts so that > it can insert the news on their sites aswell as ours... > > How can I connect to mysql on another server???? > > Thanks > > -Trond > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net