Hi!
On Jul 25, Charles Cantrell wrote:
>
> I am attempting to set up an administrative user, that has the same
> privileges as root. I have been able to set up a user that appears to have
> all privileges, with the exception of GRANT privileges to other users. This
> user can create new database tables, insert records, modify them, delete
> them and so on.
>
> But, when this user tries to GRANT privileges on any database, even ones it
> has created, an 'access denied' error is generated.
compare
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED];
and
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Only after the second comamnd [EMAIL PROTECTED] can give grants to
others.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
