Essential Pack of MySQL Admin Tools for DBAs

If you are a MySQL admin, you should have a set of MySQL administration tools to operate your databases. In this case dbForge Studio is the product you are looking for. This powerful MySQL manager contains MySQL management tools to backup databases, manipulate user accounts, manage MySQL services, etc.

MySQL administrators will find Devart dbForge Studio for MySQL convenient and helpful especially when they need to work with different tools at the same time. Our product includes all the tools a MySQL admin may need embedded in a single application.

dbForge Studio for MySQL delivers a versatile DBA toolkit!

MySQL admin tool
  • Enhanced MySQL databases backup and recovery
  • Quickest user accounts manipulation
  • Full user sessions control
  • MySQL server settings control
  • Table maintenance
  • Find object feature
  • MySQL services management
  • Available in a free Express edition!

5 things to get best MySQL administration and maintenance

Backup or restore a database for safety

As a MySQL administrator, you will surely appreciate an opportunity to save time and effort when preparing backup copies or restoring databases with convenient MySQL Backup and Restore Wizards. You can select any of five compression levels to compress your files, use auto delete of old backup files to free your disc space, and set extended options for a database to export, backup structure, users, or a script.

Read more about MySQL backup tool.


Fully control MySQL users and their privileges with Security Manager

Database security management is a key point in keeping stability of both a separate database and a large database infrastructure.

So, administering user accounts, granting and revoking privileges is the kind of work a MySQL administrator is always obliged to do. Usually such tasks require much time and effort, and are error-prone. That's why every MySQL admin would appreciate a visual MySQL admin tool that makes creating new user accounts, granting privileges, editing properties a moment's work.

Such MySQL admin tool is Security Manager from dbForge Studio for MySQL. Its window provides access to all properties of an account, allows creating and deleting users, granting and revoking privileges not only to one user, but also to several users at one go.


Boost MySQL server maintenance with special MySQL admin tools

With MySQL database administration tools, you will be able to monitor users' activity on your MySQL server, analyze status and change system variables, do all maintenance operations in an easy and convenient way.

Use such MySQL admin tool as Session Manager to simply retrieve the information about current sessions, or kill any query or session.

View and modify MySQL system and status variables with the Server Variables window. System variables indicate how the MySQL server is configured. Status variables provide information about a MySQL server operation.

Check, analyze, repair and optimize tables with ease in Table Maintenance Wizard. Launch Flush dialog box to perform flush operations in MySQL.


Find the smallest object in the biggest database

Thanks to the Find Object window, you can effectively search MySQL databases and find a required database object by any fragment of its CREATE statement, as well as find a data fragment in one or several tables. The search results are displayed in a separate window where you can quickly navigate to the found objects and perform any operations on them.



Control MySQL server instances on Windows platform

If you are a MySQL administrator and have to administer several MySQL servers on different computers, you will find Service Control essential for your work. You can start, stop and restart services, associate connections with them from one application. Try centralized administration with our MySQL manager.

Online Tutorial

Read Security Manager - Full Control of MySQL Users and Their Privileges article to learn how to efficiently manage users and their privileges to access your database.

Availability

Features Express Standard Professional

Database Backup and Restore Wizards

Click to view restrictions Yes Yes
Session Manager, Server Variables, Service Control, Table Maintenance Wizard, Flush dialog box Yes Yes Yes
Find Object window No Yes Yes

* Express Edition does not support command line, backup projects, auto deletion of old backup files, compression, backup files larger than 1MB.



  • dbForge Studio for MySQL version 6.0
  • dbForge Studio for MySQL - Code Completion
  • dbForge Studio for MySQL - Database Administration
  • dbForge Studio for MySQL - Data Management
  • dbForge Studio for MySQL - Refactoring