Bug #2999 | Incomplete "Global" permissions in MySQL Administrator 1.01a | ||
---|---|---|---|
Submitted: | 27 Feb 2004 15:54 | Modified: | 1 Mar 2004 4:44 |
Reporter: | Dan Martin | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Administrator | Severity: | S3 (Non-critical) |
Version: | 1.01a | OS: | Windows (Windows 2000) |
Assigned to: | Bugs System | CPU Architecture: | Any |
[27 Feb 2004 15:54]
Dan Martin
[1 Mar 2004 4:44]
Ulrich Bayer
I am not sure what the actual problem is. I think you are having a problem with the different hosts. A "mysql user" is the combination of a username and a hostname. Mysql Administrator tries to hide that a bit but it does not work that well obviously. Have a look at the hosts that you are allowed to connect from or just add "%" as a host by right-clicking the user in the user-list. You will also have to assign all (global) privileges to that user at the "%" host. (The % host stands for any host) There have been some bugs in the user administration that have been fixed in the meantime and will be gone in the next release. Maybe some things will also be more intuitive then. It will be possible to create databases/tables in the Mysql Administrator in the future. If there is a bug in the backup functionality that is not related to this user permissions problem, please create an extra bug report.