MySQL Workbench 5.2: Administration

User Administration

Administering users, granting privileges and viewing privilege information has never been easier. Using MySQL Workbench DBAs can visually add users, assign passwords and setup user profiles. Assigning and revoking global and database privileges is as easy as adding and removing privilege items from an available list.

Server Configuration

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

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.

Server Logs

View all the MySQL log files including error logs, binary logs, and InnoDB logs from a single, centralized administration environment to diagnose server problems quicker and track database changes.

Export/Import

MySQL Workbench also 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.

Service Control

Start and stop MySQL servers and view corresponding log messages.

System Status

Get an immediate view into the basic health indicators and counters within a MySQL environment. Simple graphs enable DBAs to easily see memory usage, connection usage, hit rates, and more.