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