Table grants not loading

I am running MySQL 4.1.1-alpha-standard on RH Linux 9. I've found strange
problem with privileges:

mysql> grant reload on *.* to 'fabackup'@'localhost';
Query OK, 0 rows affected (0.00 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.00 sec)

mysql> select * from tables_priv;
+-----------+-------+----------+------------------------+----------------+---------------------+--------------------+-------------+
| Host      | Db    | User     | Table_name             | Grantor        |
Timestamp           | Table_priv         | Column_priv |
+-----------+-------+----------+------------------------+----------------+---------------------+--------------------+-------------+
| localhost | mysql | fabackup | ibbackup_binlog_marker | root@localhost |
2004-05-17 13:28:02 | Insert,Create,Drop |             |
+-----------+-------+----------+------------------------+----------------+---------------------+--------------------+-------------+
1 row in set (0.01 sec)




After shutting down the database with:

root@blast init.d]# mysqladmin -p shutdown
Enter password:
040517 13:32:44  mysqld ended

and restarting it with:

[root@blast init.d]# /etc/rc.d/init.d/mysql start
[root@blast init.d]# Starting mysqld daemon with databases from
/var/lib/mysql

[root@blast init.d]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.1-alpha-standard

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' |
+-----------------------------------------------+
1 row in set (0.00 sec)



The create, insert, drop privilege on mysql.ibbackup_binlog_marker has
disappeared but still reported in mysql.tables_priv
table.??????!!!!!!!!!!!!!!!

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from tables_priv;
+-----------+-------+----------+------------------------+----------------+---------------------+--------------------+-------------+
| Host      | Db    | User     | Table_name             | Grantor        |
Timestamp           | Table_priv         | Column_priv |
+-----------+-------+----------+------------------------+----------------+---------------------+--------------------+-------------+
| localhost | mysql | fabackup | ibbackup_binlog_marker | root@localhost |
2004-05-17 13:28:02 | Insert,Create,Drop |             |
+-----------+-------+----------+------------------------+----------------+---------------------+--------------------+-------------+
1 row in set (0.00 sec)

mysql> exit
Bye



When logon as fabackup cannot even access mysql database.


[root@blast init.d]# mysql -ufabackup
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.1-alpha-standard

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

mysql> use mysql
ERROR 1044 (42000): Access denied for user: 'fabackup'@'localhost' to
database 'mysql'
mysql>


Am I doing something wrong here, or this is a bug. I've searched bug
database, but could not find this reported. Any help will be apprecieated.

Thanks,

Aleksandar Mihajlovic
Database Administrator




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