adding users from different servers

[sfullman]

Hi There,

Up to now I've just done this:

grant privileges on DATABASE to user identified by 'password'

now, hwever I want to be a bit more sophisticated, and give that same user access from localhost and one other external domain.

Should I execute two queries:
grant privileges on DATABASE to user@localhost identified by 'password'

grant privileges on DATABASE to user@his_server.net identified by 'password'

or is there a better way to do this?

Thanks,
Sam Fullman