List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 18 1999 9:35pm
Subject:Re: Beginner Help on privileges
View as plain text  
Try running:

mysql> FLUSH PRIVILEGES;

after you use the GRANT command.  I know it isn't supposed to be
needed, but I did need it sometimes (sorry I didn't file a good
bug report on it - I'd forgotten all about that).

Tim


On Tue, May 18, 1999 at 10:21:17PM +0100, 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 "http://www.mysql.com/Manual_chapter/manual_toc.html" 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.
> 
Thread
Beginner Help on privilegesPaul Smith19 May
  • Re: Beginner Help on privilegesThimble Smith19 May
  • Re: Beginner Help on privilegesMike Machado19 May