Jan

A Handy Program For Managing MySQL Database

MySQL Administrator is the new server management software Database MySQL has created. This is a software platform, which is available for Linux and Microsoft Windows and has a graphical user interface.

This product can fill gaps that have MySQL Control Center in the Server Management. MySQL Control Center is now deprecated, obsolete and is not developed. It was replaced by the set of programs of MySQL Administrator and MySQL Query Browser.

MySQL Administrator is a tool to perform administrative tasks on Dedicated Server.

It includes:

Configuring the boot options Servers
Starting and stopping servers
Monitoring server connections
User Management
Server health monitoring, including usage statistics
Viewing server logs
Managing backups and recoveries
Display data catalogs.

Installation and configuration:

The program can be downloaded from the MySQL website at http://dev.mysql.com/downloads/administrator , also on the website of MySQL there are a number of FAQs that assist in the installation in case of doubt, although it is fairly simple, in http://www.mysql.com/products/administrator/ .

Once installed you must configure a first connection to MySQL server for access to the administration.

In the setup, screen should specify the data server, user name, password and port, the database to which you want to connect.

Once entered correctly, the screen of the program:

From the main screen you can see the information on the database server that is connected, and the characteristics of the machine that is running the program.

In the menu bar via Tools, you have access to a system console (Windows or Linux depending on the case), a client connecting to MySQL on command line and MySQL Query Browser. From this menu, you access the administrator’s settings and connections that are configured:

In this section the stored connections to servers are configured.

Some utilities accessible from the main window are:

Service control: Starting and stopping servers (available only if connected to a MySQL server on the local machine).

Startup variables and server configuration variables start (only accessible if you have connected to MySQL server on the local machine).

User Administration: To manage users and permissions.
Server Connections: View and manage open connections to the database server.
Health: Information on server load
Server Logs: The logs record the server.
Replication Status: Using information from the replicated systems.
Backup: To back up the databases.
Restore: To restore the backup.
Catalogs: To display the database, view, create and edit tables.

Conclusion

A MySQL database was missing a tool like MySQL Administrator. No doubt this is an extremely useful and essential program for visually managing MySQL servers.

Many of the settings of the database are very simple to understand and use, at least all the basic options. In conjunction with MySQL Query Browser, allows us to manage every aspect of a MySQL database.