Re: Table grants not loading

[email protected] writes:
> I am running MySQL 4.1.1-alpha-standard on RH Linux 9. I've found strange
> problem with privileges:
> 

[skip]

> 
> Thanks,
> 
> Aleksandar Mihajlovic
> Database Administrator
> 

Hi!

This is a bug fixed long time ago. Fix is coming in 4.1.2, which will
be out in one week.

Here it is how it works:

[/mnt/work/mysql-4.1]$ ./client/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.2-alpha-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>  grant reload on *.* to 'fabackup'@'localhost';
Query OK, 0 rows affected (0.04 sec)

mysql> grant create, insert, drop on mysql.ibbackup_binlog_marker to 'fabackup'@localhost;
Query OK, 0 rows affected (0.01 sec)

mysql> show grants for fabackup@localhost;
+------------------------------------------------------------------------------------------+
| Grants for fabackup@localhost                                                            |
+------------------------------------------------------------------------------------------+
| GRANT RELOAD ON *.* TO 'fabackup'@'localhost'                                            |
| GRANT INSERT, CREATE, DROP ON `mysql`.`ibbackup_binlog_marker` TO 'fabackup'@'localhost' |
+------------------------------------------------------------------------------------------+
2 rows in set (0.04 sec)

mysql> select * from mysql.tables_priv;
+-----------+-------+----------+------------------------+------------------+---------------------+--------------------+-------------+
| Host      | Db    | User     | Table_name             | Grantor          | Timestamp           | Table_priv         | Column_priv |
+-----------+-------+----------+------------------------+------------------+---------------------+--------------------+-------------+
| localhost | mysql | fabackup | ibbackup_binlog_marker | Sinisa@localhost | 2004-05-18 16:01:06 | Insert,Create,Drop |             |
+-----------+-------+----------+------------------------+------------------+---------------------+--------------------+-------------+
1 row in set (0.04 sec)

mysql> quit
Bye
[/mnt/work/mysql-4.1]$ mysqladmin shutdown
[/mnt/work/mysql-4.1]$ ./client/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.2-alpha-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show grants for fabackup@localhost;
+------------------------------------------------------------------------------------------+
| Grants for fabackup@localhost                                                            |
+------------------------------------------------------------------------------------------+
| GRANT RELOAD ON *.* TO 'fabackup'@'localhost'                                            |
| GRANT INSERT, CREATE, DROP ON `mysql`.`ibbackup_binlog_marker` TO 'fabackup'@'localhost' |
+------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> quit
Bye


-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
       <___/   www.mysql.com   



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]