List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:May 10 2002 1:58pm
Subject:Re: RE: error granting rights
View as plain text  
It should be  'username'@'localhost'


Mark Shade wrote:

>Yep...
>
>I am in as root, so I should have rights to everything.
>
>Yep, I have confirmed that the dbname is right, but doublechecking it 
>multiple times.  Plus, this happens even on db that I did the same thing to 
>only a week ago.  The * just says "all tables" as I understand it.
>
>And, that is what I am doing - setting up the user.  That is the whole 
>point.
>
>A couple of other considerations:
>
>I have PHPMySQLAdmin running - and it runs just fine.  I can do most 
>anything with it and have no errors.  Also, I did this same thing on a 
>different db just 1 week ago with no errors.  This time, I even tried to 
>scroll back through my commands in mysql at the mysql command prompt and re-
>submit the same commands - I get the same error.  I have tried it on a 
>variety of dbs and users, but no success.
>
>Thanks for all your help,
>
>Mark
>
>>[snip]
>>mysql> GRANT ALL
>>     -> ON dbname.*
>>     -> TO username@localhost
>>     -> IDENTIFIED BY 'password';
>>[/snip]
>>
>>A. Do you have GRANT capability as the user that you are logged on as?
>>2. Is dbname.* right? Shouldn't it be just dbname?
>>III. Is user set up as username@localhost?
>>
>>Jay
>>
>>
>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>>   http://www.mysql.com/manual.php   (the manual)
>>   http://lists.mysql.com/           (the list archive)
>>
>>To request this thread, e-mail <mysql-thread108527@stripped> To
>>unsubscribe, e-mail
>><mysql-unsubscribe-mark=dmshade3.com@stripped> Trouble
>>unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread108569@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
error granting rightsMark Shade9 May
  • RE: error granting rightsJay Blanchard9 May
    • RE: error granting rightsMark Shade10 May
    • Re: error granting rightsMark10 May
      • Re: error granting rightsMark Shade10 May
        • Re: error granting rightsMark Shade10 May
    • Re: RE: error granting rightsGerald Clark10 May
  • Re: error granting rightsVictoria Reznichenko10 May