| Bug #5957 | Unable to assign privileges via MySql Administrator | ||
|---|---|---|---|
| Submitted: | 7 Oct 2004 15:50 | Modified: | 11 Oct 2004 9:34 |
| Reporter: | Mr Wakazula | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Administrator | Severity: | S2 (Serious) |
| Version: | 1.0.13 | OS: | Windows (Windows 2k) |
| Assigned to: | Bugs System | CPU Architecture: | Any |
[8 Oct 2004 15:26]
Michael G. Zinner
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
[11 Oct 2004 9:34]
Victor Vagin
Actually character set of system tables was changed in the latest version of mysql, and it became the reason of the bug. We'll add note to the manual soon (http://bugs.mysql.com/bug.php?id=6014)
[3 Nov 2004 16:04]
Tod Carrier
I opened Bug 6185 without realizing this was the same bug. I looked at the db table and found that the host column was blank. I included an example, my report attached: It appears that I am adding privileges at the database level in the Administrator. When I check those privileges, they appear to NOT be granted. I looked at the table and see this row, with no host data value. Host: Db: datatrak User: nbku52o Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y
Description: I am unable to assign schema level privileges via the MySql Administrator. I am able to assign privileges via the command prompt. DETAILS: MySql Administrator (v1.0.13) MySql (v4.1.5-gamma-nt-max) How to repeat: 1. login locally to PC running mysql 2. log into MySql Administrator (using root account) 3. click 'User Administration' 4. create a new user account 5. click 'Schema privileges' 6. select a schemata 7. click 'assign all privileges' ("<<") NOTE: the avail privileges move over to assigned privileges 8. click 'apply changes' NOTE: the assigned privileges move back to avail privileges 9. NOTE: logging into the MySql server via the command prompt shows that the permission has not been assigned