Access Hosts wont' work

[Satch]

Hi,

I need a forum to be read from 2 servers and I want the db on one of the servers and read by both. I tried adding the ip address of server2 as an access host to server1 but still no go. It looks to be as simple operation but I can't get it to work. I also tried using % as an access host. One clue that I've found is when I changed the password to the db it gave this confirmation info:

Database: your_db
Host: localhost
Username: your_username
Password: your_password

It seems that this db's only host is localhost despite having access hosts listed. How can I add another ip address and still keep the localhost?

Thanks

 

[woyteck]

make another mysql user with access to this database
and with host as other server IP.
it should help.
I think.

 

[nobaloney]

Also check your firewall to make sure the port MySQL is using isn't blocked. I'm sorry I don't know the port offhand; you'll have to look it up.

Jeff