At 11:32 PM +0200 6/6/01, Peter I. Hansen wrote:
>I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and
>I want the structure to be like this :
>1) user X can connect from '%.xxx.yy' and from 'localhost'.
>2) user X can only connect to database X.
>I can only make one out of two possibillities in 1) work at a time.
>Can you help me, Please...
mysql> GRANT ALL ON X.* TO X@localhost;
mysql> GRANT ALL ON X.* TO X@'%.xx.yy';
Paul DuBois, paul@stripped