List:General Discussion« Previous MessageNext Message »
From:J Berends Date:October 8 1999 7:37pm
Subject:Re: login problems
View as plain text  
Thanks...

The GRANT function is much easier once you knows how it works..

That's why sometimes it is good to get a little tip..

:-)

J


----- Original Message -----
From: Thimble Smith <tim@stripped>
Newsgroups: mysql.general
Sent: Friday, October 08, 1999 3:22 AM
Subject: Re: login problems


| At 22:10, 19991007, J Berends wrote:
| >what are the settings for 'Host' in the table 'user' of the 'mysql'
dbase?
|
| The best way to do this is to use the GRANT command.  Then if you
| want to know what the host field has in it, you can just select and
| find out.
|
| To let user 'buddy@stripped' have full access to database
| 'whozit', using password 'S1lv3rW4re', you would use:
|
|     GRANT ALL PRIVILEGES ON whozit.* TO 'buddy'@'fork.utensil.pie'
|     IDENTIFIED BY 'S1lv3rW4re'
|
| Tim
|
| ---------------------------------------------------------------------
| Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
| posting. To request this thread, e-mail mysql-thread15484@stripped
|
| To unsubscribe, send a message to the address shown in the
| List-Unsubscribe header of this message. If you cannot see it,
| e-mail mysql-unsubscribe@stripped instead.
|

Thread
login problemsJ Berends7 Oct
  • Re: login problemsThimble Smith8 Oct
  • Re: login problemsJ Berends8 Oct
    • Re: login problemsThimble Smith8 Oct