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!
- 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
* Express Edition does not support command line, backup projects,
auto deletion of old backup files, compression, backup files larger than 1MB.