tags 337377 - unreproducible tags 337377 - moreinfo tags 337377 + sid tags 337377 + confirmed severity 337377 grave thanks
This bugs is reproducible on sid now.
After investigating, this really sounds like the mysql-server package
changed the rights of the user debian-sys-maint, take a look at the
following:
$ mysql -uroot -p
Password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 5.0.20-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database mydbtest;
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on mydbtest.* to [EMAIL PROTECTED] identified by
'pass';
Query OK, 0 rows affected (0.00 sec)
Now the same commands with the user debian-sys-maint (which is used for
granting privileges in the postinst phase of our package).
$ mysql -udebian-sys-maint -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21 to server version: 5.0.20-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database mydbtest2;
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on mydbtest.* to [EMAIL PROTECTED] identified by
'pass';
ERROR 1044 (42000): Access denied for user 'debian-sys-maint'@'localhost' to
database 'mydbtest'
To conclude: the last version of mysql-server in sid does not allow
debian-sys-maint to grant privileges.
This sounds like a bug as when you look at the rights in the table
mysql.user, this user as Grant rights...
I'm going to contact the mysql-server(s maintainer....
Maybe this bug should be reassigned to them.
--
Alexis Sukrieh <[EMAIL PROTECTED]>
0x1EE5DD34
Debian http://www.debian.org
Backup Manager http://www.backup-manager.org
signature.asc
Description: Digital signature
