Bug #23394 error clicking on user account in User Admin
Submitted: 17 Oct 2006 21:17 Modified: 26 Oct 2006 19:50
Reporter: Peter Lavin Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.4rc OS:Windows (xp)
Assigned to: MySQL Verification Team CPU Architecture:Any

[17 Oct 2006 21:17] Peter Lavin
Description:
Clicking on a user name in User Administration raises the error shown in the attached file.

How to repeat:
Open Administrator logging in to a remote account. Choose "User Administration" and click on a user name.

(The remote account is hosted on a Linux machine.)

Suggested fix:
Show user information.
[17 Oct 2006 21:19] Peter Lavin
User Admin Error

Attachment: Create_view_priv.jpg (image/jpeg, text), 12.04 KiB.

[18 Oct 2006 13:33] MySQL Verification Team
Thank you for the bug report. Against which server version are you connecting
and the user has granted privileges to edit the grant tables?. Thanks in
advance.
[18 Oct 2006 13:55] Peter Lavin
The user does not have grant privileges. Administrator is connecting to version 5.0.24a-standard.
[23 Oct 2006 17:11] MySQL Verification Team
Thank you for the feedback. Could you please verify if you have the below
column in your user grant table?

mysql> show columns from mysql.user like "%Create_v%";
+------------------+---------------+------+-----+---------+-------+
| Field            | Type          | Null | Key | Default | Extra |
+------------------+---------------+------+-----+---------+-------+
| Create_view_priv | enum('N','Y') | NO   |     | N       |       | 
+------------------+---------------+------+-----+---------+-------+
1 row in set (0.01 sec)

Thanks in advance.
[23 Oct 2006 17:43] Peter Lavin
Find below the query as requested:

mysql> show columns from mysql.user like "%Create_v%";
Empty set (0.07 sec)
[24 Oct 2006 11:17] MySQL Verification Team
Thank you for the feedback. Could you please run the script
mysql_fix_privilege_tables and verify if that column is added
in the user grant table if yes test again with MySQL Administrator.
Thanks in advance.
[25 Oct 2006 22:41] Peter Lavin
Ran mysql_fix_privilege_tables and can now view user accounts with no errors.
[26 Oct 2006 19:50] MySQL Verification Team
Thank you for the feedback.