#2 Administration Features

[Anonymous]

Have you considered adding the ability to GRANT and REVOKE privileges through the interface? Something similar to the phpMyAdmin capabilities would be nice. CocoaMySQL is great. Thanks for working on this.

[Nobody/Anonymous]

Logged In: NO

To add on to this request, it'd be great if as mysql root, you can add users &
hosts, and then be able to specify permissions for them. thanks

[Matt Garlinghouse]

Logged In: YES
user_id=318917

Yea, this would be _really_ nice to have. Very convenient. Might as well
lump administering hosts under this umbrella (or split it out into a
different feature request). Thanks for a great app!

[Ben Fowler]

Logged In: YES
user_id=562881

See:

http://www.entropy.ch/phpbb2/viewtopic.php?p=261&
http://www.serverlogistics.com/mysql.php
http://www.creativeeyes.at/tools/mysqlpp.php
http://www.webmasterworld.com/forum49/787.htm

Now Cocoamysql is a client, and it is possible to use normal
SQL queries on the 'mysql' database to perform all user
administration. (This is either a requirement of the relational
model and/or SQL, or is so close to being a requirement
as to make no odds).

But administering a server locally, the GRANT and REVOKE
commands you speak of, seems to me to be slightly different;
and I wouldn't complain if Cocoamysql never had this feature.

If such a feature were added, I personally would welcome it; and
I would use it.

More significantly, I think that you are spot on when you
make the comparision with phpMyAdmin. If this feature is
seen as plus there, it is a good pointer to the wisdom of
incorporating it here.

In the meantime, perhaps we should think about either:

1) Beefing up one of the three (!) Prefpane projects
2) Create a Cocoamysqladmin application (which
could be merged in Cocoamysql if the devs here
wanted it, that wrapped around mysqladmin, for things
like: Root password, GRANT and REVOKE.