GUAM is, as the name implies, a GUI frontend to allow easy administration of MySQL users. It is written in Java and uses the Swing toolkit. Since it is a pure Java application, it is completely cross-platform and should work on any platform that has a full Java implementation (and maybe even some of the cut-down implementations). GUAM is released under the GNU General Public License (GPL).
GUAM IS NOT CURRENTLY MAINTAINED
GUAM is Copyright (c) 2002 David Currie (dave@noaxs.net).
NOTE: GUAM is BETA software. It might have (probably has) many bugs and "undocumented features". If you find any bugs, please drop me an e-mail including as much information as possible and where possible instructions on how to reproduce the bug.
GUAM requires the following to run:
Usage of GUAM is quite simple if you are vaguely acquainted with MySQL user administration. Also, the buttons and menus are quite self-explanatory. The following is just a basic walk-through to get you started on doing something useful.
The first thing you have to do is add a database to the database list (Config/Add Database menu item). In this popup window insert the information for your MySQL server. You can do this for as many servers as you like, just remember that each server is uniquely identified by it's name. Remember that you should configure a user that has GRANT privileges on whatever you want to administer.
To modify the information for a configured database, select it in the combo box and click on Configure->Modify Database. To delete a configured database, click on Configure->Delete Database instead.
When you have some servers configured, select the one you want to use and click on the Connect button or the File/Connect menu item. If the connection is successful, you will see a list of users on the server. Note that the list of users is in user@host format, which is how MySQL stores user data. It is not an error to see several entries where the username is the same but the hostname is different. See the above-mentioned manual entries for more information.
To add a user, click on the New button and enter the username and password into the displayed fields.
To delete a user, select the desired username and click on the Delete button.
To modify a user's data, select the desired user and click on the Modify button. After a short pause (while GUAM builds up the database structure) a window will appear with the database tree. From here you can assign privileges at the global-, database-, table- or column-level simply by selecting the desired element in the tree. Each of the possible types of privileges that can be applied on an element are displayed as checkboxes beside the tree. The current status is displayed and can be modified at will.
Note that while you can edit privileges on any number of elements, if you click on Modify all the changes will be saved and if you click Cancel all changes will be lost. There is no partial undo functionality (yet).
To modify a user's password just click on the Password button and type in the new password. Password changes are independent of the rest of the privilege modification system, i.e. if you change a user's password and then click on Cancel the password will remain changed.