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' [at] 'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> grant create, insert, drop on mysql.ibbackup_binlog_marker to
'fabackup' [at] localhost;
Query OK, 0 rows affected (0.01 sec)
mysql> show grants for fabackup [at] localhost;
+----------------------------------------------------------- -------------------------------+
| Grants for fabackup [at] localhost
|
+----------------------------------------------------------- -------------------------------+
| GRANT RELOAD ON *.* TO 'fabackup' [at] 'localhost'
|
| GRANT INSERT, CREATE, DROP ON `mysql`.`ibbackup_binlog_marker` TO
'fabackup' [at] '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 [at] localhost |
2004-05-17 13:28:02 | Insert,Create,Drop | |
+-----------+-------+----------+------------------------+--- -------------+---------------------+--------------------+--- ----------+
1 row in set (0.01 sec)
After shutting down the database with:
root [at] blast init.d]# mysqladmin -p shutdown
Enter password:
040517 13:32:44 mysqld ended
and restarting it with:
[root [at] blast init.d]# /etc/rc.d/init.d/mysql start
[root [at] blast init.d]# Starting mysqld daemon with databases from
/var/lib/mysql
[root [at] 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 [at] localhost;
+-----------------------------------------------+
| Grants for fabackup [at] localhost |
+-----------------------------------------------+
| GRANT RELOAD ON *.* TO 'fabackup' [at] '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 [at] 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 [at] 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' [at] '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 [at] m.gmane.org
