MySQL Bugs: #2999: Incomplete "Global" permissions in MySQL Administrator 1.01a

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:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.01a	OS:	Windows (Windows 2000)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
Running Administrator 1.01a on Windows 2000, connecting to MySQL 4.018 for Windows running on Windows NT Workstation 4.0 sp6a. I have found that Administrator is unable to assign full "global" permissions to a user even when the "global" option is checked. I can only assign global permissions using mysqlcc; something is missing from the permissions in Administrator

How to repeat:
Having created a user through Administrator logged on as root (on the NT machine as localhost), I tried to assign that user global permissions, then tried to use that user to create a new table and import records using a restore from an *.sql file. Error returned was "An Error occurred while executing the backup. The MySQL Server returned this Error: MySQL Error Nr. 1044 Access denied for user 'username@host' to database 'database name'.

Likewise, when I tried to go to user administration, I got the error "Could not fetch Usernames. MySQL Error Nr. 1044 Access denied for user 'user@host' to database 'mysql'.

Suggested fix:
The only way I've found to create the global permissions is to log onto the database from the local host using MySQL-CC beta 0.94, set global permissions from there, then log on from wherever I want to do the rest. Whatever mysqlcc does, Administrator needs to be able to do.

Even then, the restore from sql doesn't work using Administrator, though the same restore works without a hitch in mysqlcc.

Also, there is no option to create a new table or database in Administrator; these functions work fine in mysqlcc.

I'll be happy to provide more detail if/when you wish, though I don't have time to get on a discussion group.

Cheers,

Dan

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.