After you've filled the user and db tables in the mysql database, just give
the command

mysql> flush privileges;

The privileges will be reread. It's easier if you're tuning the whole story.

GRTNX, 
Ton Geurts


-----Oorspronkelijk bericht-----
Van: Gerlinde Fischer [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 9 juli 2001 11:11
Aan: Prabu Subroto; [EMAIL PROTECTED]
Onderwerp: Re: defining allowed host for mysql


Have you filled out the tables
user, db
in mysql.
And after filling this tables
you must start mysqladmin reload.


Regards Gerlinde
At 01:11 09.07.01 -0700, Prabu Subroto wrote:
>I tried to connect to my mysql server but there was
>always an error message saying "this host is not
>allowed".
>Anybody so kind to tell me, "how can I define the
>hostname/computer name in my mysql server to be
>allowed connect to my database server and use my
>kmysqladmin and kmysql software".
>
>Thanks in advance.
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
>
>---------------------------------------------------------------------
>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

               BLITZ Internet Service GmbH
                       Kronacher Strasse 41
                     D-96052 Bamberg, Germany
            Tel. +49/951/9685160, Fax +49/951/9685164
                       http://www.blitz.net 

---------------------------------------------------------------------
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

---------------------------------------------------------------------
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

Reply via email to