"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Marcin Blazowski" <[EMAIL PROTECTED]> wrote: > > "Marcin Blazowski" <[EMAIL PROTECTED]>> wrote: > >>> I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS
> To be able give permissions to other users you should have UPDATE privilege and GRANT option. > > > 2. Why everything works like I expect (I can grant privileges with the way > > described above, User doesn't have UPDATE privilege) on my MySQL compiled > > from sources on RedHat? > > Could you be more detailed? Show me an example, i.e. what permissions does user have? Now, I'm not sure if it worked OK. I've moved to 4.0.14 and it don't. I have the same problem but I've discoverd some new feature (Ed Brown send a news to this group at 19-07-2003 16:57, subject: "creating db admins"). Like Ed Brown I can't grant my privileges to other user and setting a password for him. Below is the long example what I do: mysql> select user, grant_priv, insert_priv, update_priv from user; +------+------------+-------------+-------------+ | user | grant_priv | insert_priv | update_priv | +------+------------+-------------+-------------+ | root | Y????????? | Y?????????? | Y?????????? | | root | Y????????? | Y?????????? | Y?????????? | +------+------------+-------------+-------------+ 2 rows in set (0.00 sec) mysql> show databases; +----------+ | Database | +----------+ | mysql??? | +----------+ 1 row in set (0.00 sec) mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo' w ith grant option; Query OK, 0 rows affected (0.05 sec) mysql> flush privileges; Query OK, 0 rows affected (0.02 sec) mysql> select user, grant_priv, insert_priv, update_priv, host from user; +-------+------------+-------------+-------------+-----------+ | user? | grant_priv | insert_priv | update_priv | host????? | +-------+------------+-------------+-------------+-----------+ | root? | Y????????? | Y?????????? | Y?????????? | localhost | | root? | Y????????? | Y?????????? | Y?????????? | %???????? | | blazo | N????????? | N?????????? | N?????????? | localhost | +-------+------------+-------------+-------------+-----------+ 3 rows in set (0.00 sec) mysql> select user, db, grant_priv from db; +-------+------+------------+ | user? | db?? | grant_priv | +-------+------+------------+ | blazo | temp | Y????????? | +-------+------+------------+ 1 row in set (0.00 sec) mysql> exit Bye C:\mysql\bin>mysql -u blazo -p Enter password: ***** Welcome to the MySQL monitor.? Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.14-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database temp; Query OK, 1 row affected (0.01 sec) mysql> grant select on temp.* to [EMAIL PROTECTED] identified by 'haslo'; <----------- ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' mysql> grant select on temp.* to [EMAIL PROTECTED]; <---------- Query OK, 0 rows affected (0.00 sec) mysql> exit Bye C:\mysql\bin>mysql -u root Welcome to the MySQL monitor.? Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.14-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql Database changed mysql> select user, host, grant_priv, update_priv, insert_priv from user; +--------+-----------+------------+-------------+-------------+ | user?? | host????? | grant_priv | update_priv | insert_priv | +--------+-----------+------------+-------------+-------------+ | root?? | localhost | Y????????? | Y?????????? | Y?????????? | | root?? | %???????? | Y????????? | Y?????????? | Y?????????? | | blazo2 | localhost | N????????? | N?????????? | N?????????? | | blazo? | localhost | N????????? | N?????????? | N?????????? | +--------+-----------+------------+-------------+-------------+ 4 rows in set (0.01 sec) mysql> select user, grant_priv, db from db; +--------+------------+------+ | user?? | grant_priv | db?? | +--------+------------+------+ | blazo? | Y????????? | temp | | blazo2 | N????????? | temp | +--------+------------+------+ 2 rows in set (0.00 sec) So, Why the first of the matched lines don't work and the second works OK. Why I can't create user with a password set? You said that the user must have UPDATE privilege on mysql.* to grant his rights to other user. How can I give him that right and be sure that his is not able to change root (or any other user) password? Thanks a lot for answer. Marcin Blazowski -- Marcin Blazowski Incenti SA tel. +48 71 370 74 50 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
