List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 29 1999 9:09pm
Subject:Re: User Error
View as plain text  
On Mon, 1999-08-30 02:26:47 +0530, Sandeep Sawhney wrote:
> insert into user (host,user,password)
> values('localhost','hitjobs1',password('hobxxx'));
> 
> insert into db (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,
>         Create_priv,Drop_priv)  values
> 'localhost','hitjobs','hitjobs1','Y','Y','Y','Y','Y','Y');
[...]
> ERROR 1045: Access denied for user: 'hitjobs@localhost' (Using password: YES)
> 
> what could i be doing wrong ..

Excert from chapter "6.9 When privilege changes take effect" of the
MySQL manual:
| When mysqld starts, all grant table contents are read into memory
| and become effective at that point.
| 
| Modifications to the grant tables that you perform using GRANT,
| REVOKE, or SET PASSWORD are noticed by the server immediately.
| 
| If you modify the grant tables manually (using INSERT, UPDATE,
| etc.), you should execute a FLUSH PRIVILEGES statement or run
| mysqladmin flush-privileges to tell the server to reload the grant
| tables. Otherwise your changes will have no effect until you restart
| the server.

So did you issue the SQL command
   FLUSH PRIVILEGES
or did you run the shell command
   mysqladmin flush-privileges
?

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
User ErrorSandeep Sawhney29 Aug
  • Re: User ErrorMartin Ramsch29 Aug
  • Re: User ErrorPaul DuBois29 Aug
  • User ErrorMichael Widenius29 Aug