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.