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. Connections in MySQL Workbench are updated with the certificates by the wizard. The SSL Certificate Wizard helps create proper SSL certificates for both MySQL clients and MySQL servers.

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. MySQL Workbench allows DBAs to easily view and edit general and advanced parameters to quickly fine tune MySQL servers. Assigning and revoking global and database privileges is as easy as adding and removing privilege items from an available list.

Using MySQL Workbench DBAs can visually add users, assign passwords and setup user profiles. User AdministrationĪdministering users, granting privileges and viewing privilege information has never been easier. MySQL Workbench provides a powerful grid view and enables DBAs to quickly page through data and sort across nine attributes such as user, ip, activity type, date and time. Using built in filters and text search, DBAs can easily find suspect activity in your audit trails. AuditingĮasily enable MySQL Enterprise Audit and see who did what, when, where and how. When its time to restore, the GUIs assesses the history - what, when, and where - and steps a DBAs through the recovery process. Simple to setup, run, schedule, and view backups while in progress, this tool helps to quickly put proper backups in place. Easily create and manage online MySQL backups using the Workbench GUI for MySQL Enterprise Backup.

Online mysql workbench