34,333
edits
Changes
→Using the MySQL Administator
* '''Replication''' - Provides a visual overview of the replication master and slaves. Icons beside each machine indicate which slave machines are connected to the master and which are currently off-line.
* '''Catalogs''' - Allows catalogs, tables, schemata and tables to be viewed. Also allows new databases and tables to be created. A list of existing catalogs and schema is located in the bottom left corner of the screen, enabling an existing entry to be selected and edited. This screen is not only a good way to create databases and tables, it is also invaluable as a tool for learning about the layout of existing databases and tables. This topic is covered in detail in [[Create Creating New Databases and Tables with MySQL Administrator]].
== Summary ==
The MySQL Administrator provides an easy to use and user friendly way to administer many aspects of a MySQL server and related databases. A description of the full capabilities of this tool are beyond the scope of this chapter, but given intuitive nature of the tool, simply exploring the different screens will quickly bring the user up to speed.