At 6:13 AM -0500 6/4/99, Online Designs wrote:
>Ok, I'm totally ignorant....before I GRANT priveleges do I have to
>setup the username first? If there is already a username on my server
>that I would like to have MySQL access, for example - pastures, do I
>put in pastures@localhost?
GRANT will create the user table entry for you.
REVOKE, on the other hand, will revoke privileges, but it never removes
a user table entry. To do that you must issue a DELETE FROM user WHERE ...
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/