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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php