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: | |
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
[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.