On 3/14/03 3:51 PM, "Barney Boisvert" <[EMAIL PROTECTED]> spit this
out onto my computer screen:
> These are idiotic questions, but i've been bit by such things:
>
> did you spell the database name correctly in both the GRANT statement for
> you user?
> did you give the user appropriate permissions?
> did you spell the username and password correct?
>
> if you can connect with security turned off, then it has to be something
> with your security data.
This is exactly how I created the user:
Mysql> GRANT SELECT, INSERT, UPDATE, DELETE,
->CREATE, DROP, ALTER, INDEX, FILE ON
->addressbook.* TO [EMAIL PROTECTED]
->IDENTIFIED BY 'password';
This was taken direct from a mysql book, and I have recreated the user over
15 times, so the chances of me fudging that everytime are slim... BUT if you
see an error in the syntax, maybe my book is wrong.
I also created one like this too:
Mysql> GRANT SELECT, INSERT, UPDATE, DELETE,
->CREATE, DROP, ALTER, INDEX, FILE ON
->addressbook.* TO user@'%'
->IDENTIFIED BY 'password';
So ideas now?
d
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
