Special privileges required to view database from another server? 2

[MatthewP]

I can connect to my database fine on its own server, but I cant seem to connect to this from another server. I know I've got the syntax right - do I need to set up special permissions for this? Eg. Currently the user has localhost as the first field. Should this be something else to allow him/her to connect from a different server? Or is the problem something else?

Thanks,
Matt.

 

[devnull22]

yes

mysql> \u mysql;
mysq>INSERT INTO user (user,host,password,...)
VALUES ('user_id','%',password('password'),...);
mysql>flush privileges;

where '%' allows user to connect from anywhere, you could
replace '%' when the hostname of the remote computer.
where '...' are user permission fields .

hope this helps. devnull22

http://www.kbcenter.com

(Knowledge Base Center )

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[MatthewP]

So that's what that % sign's about.. thanks!