What is MySQL Workbench?

MySQL WORKBENCH is a Visual database designing and modeling access tool for MySQL server relational database. It is a unified visual tool for database architects, developers, and DBAs.

It provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. The purpose of MySQL workbench is to provide the interface to work with databases more easily and in a more structured way. MySQL Workbench is available on Windows, Linux and Mac OS X.

MySQL Workbench: Administration

MySQL Workbench integrates database administration tools into a simple to use graphical user interface. The visual console enables DBAs to easily perform operations such as configuring servers, administering users, export and import, and viewing logs.

“Do you have a design in mind for your blog? Whether you prefer a trendy postcard look or you’re going for a more editorial style blog - there’s a stunning layout for everyone.”

Server administration plays a critical role in securing the data of the company. The major issues concerning server administration are users' management, server configuration, server logs and many more. Workbench MySQL has the following features that simplify the process of MySQL server administration;

Server configuration : allows DBAs to easily view and edit general and advanced parameters to quickly fine tune MySQL servers.

Server logs : visual tool for viewing MySQL server logs. The logs include error logs, binary logs and InnodDB logs. These logs come in handy when performing diagnosis on the server. The figure shown below shows the modeling window for MySQL Workbench.

Server Connections : Improve server management with a comprehensive view of all server connections and visual tree based navigation provides detailed information about server and status variables, including number of threads, bytes sent and received by clients, buffer allocations size, and more.

Service Control : Start and stop MySQL servers and view corresponding log messages.

Backup/Recovery : Easily create and manage online MySQL backups using the Workbench GUI for MySQL Enterprise Backup.Simple to setup, run, schedule, and view backups while in progress, this tool helps to quickly put proper backups in place. When its time to restore, the GUIs assesses the history - what, when, and where - and steps a DBAs through the recovery process.

User administration : visual utility for managing users that lets database administrators easily add new and remove existing users if need arises, grant and drop privileges and view user profiles.

Export/Import : MySQL Workbench includes visual tools for mysqldump. Easily export/import data by selecting the database schemas and/or tables from the Object Browser. Advanced configurations are available for concurrency controls, backup type, and output formatting.

System Status : Get an immediate view into the basic health indicators and counters within a MySQL environment. Easily see key values such as available features, primary server directories, replication state, and security settings for authentication and ssl. Simple reports and graphs enable DBAs to easily track memory usage, connections, hit rates, and more.

The figure shown below shows  the Admin panel for Workbench MySQL .