Key features: Includes support for MySQL server versions 3.23-5.x, MariaDB server versions 5.5 and 10.0, Percona and Amazon RDS. Administration and Maintenance. Tools for MySQL database administration and management include means for managing user privileges, MySQL service control, managing server variables, table maintenance. Data Analysis. Data Comparison and Sync. Data Editor. Database Backup. Dump databases in SQL format and schedule regular MySQL database backups. Database Explorer. Database Refactoring. Renaming tables, columns, views, procedures, functions and indexes. Possibility to generate refactoring script of a database without changing it. Debugger. The first debugger for MySQL that offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of MySQL stored routines and triggers and keeps MySQL server's logic of procedure execution. Exporting and Importing Data. Flat Table Editor. Object Editors. Database Projects. Query Builder. Query Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Schema Comparison. SQL Editing and Execution. Visual Database Designer. Pluggable authentication is supported. The product provides the extended support of pluggable authentication modules for MySQL servers. Connection to Sphinx Search Engine is supported. Phrase Completion.
What's new in this version:
Version 7.0.49 Support for MySQL 5.7; Support for the PASSWORD EXPIRE option in Security Manager; Support for computed columns; Support for the JSON Data Type; Support for Spatial Indexes; Support for Percona PAM authentication; Support for the Amazon Aurora connection; Improved code refactoring.