List:General Discussion« Previous MessageNext Message »
From:Mike Machado Date:May 19 1999 6:05am
Subject:Re: Beginner Help on privileges
View as plain text  
Did you do mysqladmin reload after you inserted a row into the user table?

Paul Smith wrote:

> Hi,
> I am new to SQL and have a couple of problems.  I have MySQL running on NT4
> fine.  I can issue queries to the database and retrieve records, create new
> tables, etc.
> I have a problem with the security side. I have tried to add users as per
> the manual.  Similar to what follows.
> shell> mysql --user=root mysql
>  mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY
> 'something' WITH GRANT OPTION;
> however...  The user never seems to appear in the user table and I cannot
> logon using that user ID.  I can issue an sql insert statement to add the
> user, but despite it then appearing in the table, I still can't logon with
> that user.  At the moment I can only log on as root!
> Regards, Paul
> ---------------------------------------------------------------------
> Please check "" before
> posting. To request this thread, e-mail mysql-thread3533@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.

Mike Machado
Network Specialist

Beginner Help on privilegesPaul Smith19 May
  • Re: Beginner Help on privilegesThimble Smith19 May
  • Re: Beginner Help on privilegesMike Machado19 May