Independent Digital

Creating and managing dynamic websites using Php, MySql, HTML and Wordpress with a bit of PEAR on the side

Entries Comments



Email This Post    Print This Post   

Administering your MySQL database with MySQL Administrator

24 May, 2007 (14:01) | MySQL | By: clive



MySQL Administrator

MySQL Administrator is a visual administration console that enables you to administer your MySQL environment. It integrates database management and maintenance into a single environment, with an intuitive graphical user interface.

MySQL Administrator enables you to perform all the command line operations visually.

These include:

  • configuring servers
  • administering users
  • monitoring database health
  • monitoring replication status
  • backup and restore
  • viewing logs
  • User Administration in Minutes

    MySQL Administrator makes it very easy to administer users, to grant privileges and view user privilege information.

    Single View Dynamic Health Monitoring

    Dynamic health monitoring displays the key indicators of the health of your MySQL environment. Dynamic graphs enable you to see percentage of memory usage, connection usage, hit rates, as well as the number of SQL queries on an ongoing basis.

    Quickly Optimize MySQL

    MySQL Administrator allows you to view and setup key parameters of your database so that you can quickly optimize its performance.

    Rapid Disaster Prevention and Recovery

    MySQL Administrator allows you to visually select the schemas and tables you want to backup/restore from your hierarchical data directory. Creating the backup or restoring from a backup is then very easy.

    Server Information At-a-Glance

    MySQL Administrator allows you to quickly view basic information about the server and client. It enables you to view items such as server status, client and server version numbers and IP address, as well as connection information.

    View Replication Status

    MySQL Administrator allows you to easily view the network topology of your replication master and slaves.

    View Server Logs from a Centralized Administration Environment

    You can view all the MySQL log files including error logs, binary logs, and InnoDB logs from a single, centralized administration.

    Service Control

    MySQL Administrator gives you complete control of service creation. Including the starting and stopping of the MySQL server.

    Browse Catalog

    MySQL Administrator enables you to browse your catalog and view corresponding tables with columns, all indices and users with privileges to access selected databases. You can also monitor and optimize tables from here.

    Cross Platform

    MySQL Administrator is available for Microsoft Windows, Linux and Mac OS X.

    Download MySQL Administrator for FREE!

    You can download MySQL Administrator here.


    Sorry, there are no related posts but check these out