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:
>I'm currently adding users to a MySQL server on a LAN (, and
>I want the structure to be like this :
>1) user X can connect from '' 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
permissionsPeter I. Hansen6 Jun
  • Re: permissionsPaul DuBois7 Jun
  • Re: permissionsRolf Hopkins7 Jun