>LdS> I'm experiencing the same problem.
>LdS> But I sort of found a way around it (though I'm sure this is not really the
>right way).
>LdS> When I "remove" the *password* for *root* and login again as root, I'm able to
>create new users using GRANT then flush priviliges.
>LdS> Does this mean I have to indicate the password of root while using GRANT?
>LdS> I can't find any info on this on the docs, please point us to where we can find
>the info for this.
>LdS> thanks...
>
>Yes, using GRANT statment you can set password for user.
>Look at: http://www.mysql.com/doc/G/R/GRANT.html
>
I still end up having a user with all privileges set to *N*, eventhough I created that
user with
mysql> grant all privileges
> on dbase1.*
> to user1 identified by 'user1password';
What am I doing wrong?
luie
__________________________________
www.edsamail.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php