"Marcin Blazowski" <[EMAIL PROTECTED]> wrote: > I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to > that database. When logon with that new user and want to create a new user > with some privileges a get an error. > > How I do it: > > mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by > 'haslo' with grant option; > Query OK, 0 rows affected (0.00 sec) > > Now, I logon as user temp and create database temp: > > mysql> create database temp; > Query OK, 1 row affected (0.01 sec) > > And finally I try to give some of my privileges to user temp2: > > mysql> grant insert on temp.* to [EMAIL PROTECTED] identified by 'haslo'; > ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' > > And I get an access denied error. > > What's wrong? I know that it should work but it doesn't. > It works with MySQL 4.0.12 compiled by me from sources on RedHat. > It doesn't work with 3.23.49 installed from deb on Debian. > It doesn't work with 4.0.12 installed from binary distribution on Windows > 2000. > > I think it is because of a configuration of MySQL. But what I have to > change? Maybe it is something else?
User must have UPDATE privilege on the database mysql to grant rights to other users. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]