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