Table grants not loading
am 18.05.2004 00:18:35 von aleksandar.mihajlovicI 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/bugs?unsub=gcdmb-bugs@m.gmane.org