MySQL Bugs: #23788: Missing Assigned Privileges for same account

Bug #23788	Missing Assigned Privileges for same account
Submitted:	31 Oct 2006 1:27	Modified:	13 Sep 2007 11:22
Reporter:	Robert Gebis	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.5beta	OS:	MacOS (Mac OSX 10.4.8)
Assigned to:		CPU Architecture:	Any

Description:
This is bug related to Bug #23785. Selecting Account and than robert -> % and than selecting db1 vs db2 and selecting Schema Privileges shows that one has all the other does not have any.
Running 
mysql > show GRANTS for robert;

show this

+------------------------------------------------------------------------------------+
| Grants for cme@%                                                                                   |
+------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'robert'@'%' IDENTIFIED BY PASSWORD 'this is encrypted password'                                                                         | 
| GRANT ALL PRIVILEGES ON `db1`.* TO ''robert'@'%'                                                                             | 
| GRANT ALL PRIVILEGES ON `db2`.* TO 'robert'@'%'                                               | 
+------------------------------------------------------------------------------------+

How to repeat:
Just follow the direction above

Still the same problem in 1.2.5b

Could not reproduce the problem with MA 1.2.5rc.

I have following grants:
mysql> show grants;
+----------------------------------------------------+
| Grants for u@localhost                             |
+----------------------------------------------------+
| GRANT USAGE ON *.* TO 'u'@'localhost'              | 
| GRANT ALL PRIVILEGES ON `db1`.* TO 'u'@'localhost' | 
| GRANT ALL PRIVILEGES ON `db2`.* TO 'u'@'localhost' | 
+----------------------------------------------------+
3 rows in set (0.00 sec)

And they appear to be shown properly in MA. 

The database in background is 5.0.29.

Could you please try 1.2.5rc, as well as send general query log from MySQL for this issue as well?

Hello, That is strange but if I create the test db as I described and it works fine. But for some strange my real schema has problem. Perhaps I could send you some info about this? I do not want to post my schema  here. Are there any other ways we can communicate/exchange files?

Any files or comments can be marked as 'private', hence not being revealed to general public. Feel free to share, of course, by eliminating non-necessary bits you may have more security too.

Let me know if you have new build and want me to test it or report additional traces

as 'SHOW PROCEDURE STATUS' does not show one procedure, full SQL dump of mysql.* tables is needed - it can be attached as a private file too.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Thank you for the feedback.

We didn't answered long time because didn't get notification about attached private file.

Please provide output of mysqldump -R --no-data for cmed and cmemcrouter databases.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Please try with current version 1.2.12 and if problem still exists provide information I requested in previous comment.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".