2 hosts accessing 1 MySQL database?

[Prezident]

Does anybody know of a way I can have 2 different hosts access 1 database?

I have information that needs to be sent to the database from a remote server, and of course I will also need to be able to access that database from the local machine also.

I have tried different ways to put 2 host names in the "Host" field when setting up a mysql database through DSM, but nothing seems to work.

'localhost', 'remotehost'
"localhost", "remotehost"
'localhost'; 'remotehost'
"localhost"; "remotehost"

None of those have worked so far. Any suggestions would be greatly appreciated.

[LeeJ]

create a user for each host and grant each use access based on the hosts ip or domain.

[Prezident]

thanks, I will give that a shot.