List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 7 2001 12:48am
Subject:Re: permissions
View as plain text  
At 11:32 PM +0200 6/6/01, Peter I. Hansen wrote:
>Hi
>
>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...
>
>Peter Hansen

Sounds like:

mysql> GRANT ALL ON X.* TO X@localhost;
mysql> GRANT ALL ON X.* TO X@'%.xx.yy';

-- 
Paul DuBois, paul@stripped
Thread
permissionsPeter I. Hansen6 Jun
  • Re: permissionsPaul DuBois7 Jun
  • Re: permissionsRolf Hopkins7 Jun