Home > Databases Tools > MySQL Front

MySQL Front

MySQL Front

A MySQL front end can join ease of use with a powerful MySQL GUI. MySQL Front is a GUI for the MySQL database, you can offer a more refined user interface than is possible with systems built on PHP and HTML. A Windows GUI application, it has total control of the graphic display, information can be presented as clearly as possible.

MySQL-Front presents a uniform front-end for all of your current database projects. Defining and managing the importing data, editing data is now simple with this full featured program. For designers with only a basic grasp of databases, this program is the way to go to make you independent of SQL gurus.

MySQL-Front makes working with MySQL databases a snap without hiding the language from the user. The built-in SQL Editor provides syntax highlighting and context sensitive help, so even working with SQL commands and scripts will be a matter of convenience. MySQL-Front can make direct contact with the database. Otherwise, only one small script needs to be installed on the publishing website. Login information are stored on your hard disk, so you no longer have to log on to different web interfaces.

Easy management of all MySQL objects

  • Support of all MySQL TABLE types (including transaction-safe-tables)
  • Creating/Editing/Dropping users
  • Easy management of all MySQL objects
  • Creating/Dropping databases
  • Creating/Alter/Dropping Schedule Events ( MySQL Server 5.1)
  • Creating/Editing/Dropping foreing keys
  • Creating/Alter/Dropping tables
  • Creating/Editing/Dropping index
  • Creating/Dropping Stored Procedures ( MySQL Server 5.0)
  • Creating/Alter/Dropping/Viewing/Editing data in Tables ( MySQL Server 5.0)
  • Creating/Alter/Dropping Triggers ( MySQL Server 5.0)
  • Support of all field types (including BLOBs)

Powerful data manipulation tools

  • Powerful BLOB Viewer/Editor with several types of viewing BLOB data
  • Export data to SQL script as INSERT statement
  • Advanced Grid Options. ( Copy and Paste records for Ms Excel)
  • Grid Fileters.
  • Grid Group, Sort and Summarize information.
  • Export data in to 14 popular formats like MS Access, MS Excel, MS Word , HTML.
  • Import data from in 7 popular formats like MS Excel, MS Access, XML, TXT and CSV.

Data / Data Structure Export

  • SQL File
  • Text File (CSV format)
  • HTML File
  • XML File
  • SQLite File
  • MS Excel File

High-Degree of Compatibility

  • If the ISP prohibits external access to the database a HTTP tunnel can be used to have access the database nevertheless
  • Supports MySQL databases starting with version 3.23 Microsoft Windows starting with Windows 95
  • Intensive internal usage of the Windows API to make sure to be compatible with future Windows versions

Data / Data Structure Import

  • SQL File
  • Text File (CSV format)
  • MS Access File
  • MS Excel File
  • SQLite File
  • ODBC (Open Database Connector)

Enhanced Database Manipulations:

  • Detailed Search inside whole table(s) / database(s) with regular expressions
  • Fast Search&Replace inside whole table(s) / database(s)
  • Whole database / table transfer between two different servers
  • Easy Synchronisation between two servers / databases / tables

ER Modeling:

  • Backward engineering
  • Forward engineering

Database Administration:

  • Highly individualized user rights administration
  • Security settings on host level
  • Table maintenance support (check, analyze, optimize, repair and “flush tables”)
  • Overview and ending of single processes and the entire serverConfiguration of server variablesDetailed server status overview Sh
  • owing server error log and slow execution log

Efficient Troubleshooting:

  • Distinct filtering and data sorting functions
  • of source code of databases, tables, views, routines, events, triggers, users, hosts and processes
  •  Stored Procedures, Stored Functions, Triggers and Events can be executed for debugging with a single mouse click. Test data can be set and the result will be shown right beside the source code editor
  • Logging of SQL queries sent to the database
  • Printout of data, data structure and source code syntax highlighting

Rapid development:

  • Database queries can be developed with a visual query builder by Drag&Drop
  • Editing values in the result set of an executed query in the SQL Editor and Query Builder
  • Management of user-defined SQL scripts
  • All database objects can be created, changed and removed without writing any SQL statement
  • Context sensitive help of the SQL in the SQL Editor
  • Executing partial selected SQL statements in the SQL Editor
  • The source of Stored Procedures, Stored Functions, Triggers and Events can be edit easily - MySQL-Front handle the updates with a single key pressing

Download Now