mysql connect to another domain

[flashman]

i have admin file using it i change some text on site every day. But i need that text will appear on other 3 websites at the same time. I tried connect to mysql databases on another sites but i can't.

My connect string on server likes it:
localhost
user
password

but i can't connect using such way:
www.webdomen.com
user password

Is there another way to do it?

[jatar_k]

it must be the server string, are you sure that is correct?

If you were going to telnet or ssh to your server that contains the mysql db is that the server name that you use? Maybe you could give your host a call and see what server name to use to connect from another server.

[mcavic]

Is there a firewall between the servers?

Oh - also, the mysql server has to be configured to allow connections from that particular client.

mysql> use mysql;
mysql> select host, user from user;
+-----------+------------+
¦ host ¦ user ¦
+-----------+------------+
¦ localhost ¦ mcavic ¦
¦ localhost ¦ root ¦
+-----------+------------+

The host column should list the host name of the client you're connecting from, according to DNS. Do an nslookup of the client's ip address to get the correct name. Or use % (I think) to allow all clients.

[flashman]

Thanks for asnwers. I still have nothing. There's no firewall between servers. Anyway thanks.

[justageek]

I've seen problems with dns and Windows. If you windows then use the ip of the other database. Never had a problem since.