Hello all

I'm using MySQL version mysql-max-3.23.55 on Sun Solaris 8 (sparc)

Control center version 0.8.10 beta on Windows 2000 (with sp3) and Windows XP
(sp1)

Using mysql cc I login with the root mysql account (the account does have a
password set). I then create a database (for ex. "list") Then I go into the "User Administrator", double click the "root@%" user,
highlight and check the "list" database, check all privileges, check with grant option and click
apply. I get the error

[newton] ERROR 1045: Access denied for user: 'root@myhostname' (Using password:
YES) [newton] ERROR 1044: Access denied for user: 'root@myhostname' to database
'list' An error occured while applying the Grants.

If I login to the server, su to root then run

---------------- [root@newton bin]# ./mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 328 to server version: 3.23.55-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL ON list.* to "root"@"%" IDENTIFIED BY "xxxxxxxxx"; Query OK, 0 rows affected (0.01 sec)

---------------

It works

I can then login with the control center again and double click the user and
highlight the database and see that I have all the privs.

I know I probabbly didn't give root full remote privs somehow but I cant figure
out how to do it.

Thanks for any help