EngInSite Client for MySQL

Version 2.0.4 build 231

This all-in-one tool will help you create, manage and edit MySQL databases. One intuitive interface for all tasks. Supports all releases of MySQL from 4.02 to 5.XX and all of the latest MySQL features including views, triggers, stored procedures and functions as well as InnoDB foreign keys.

Defining and managing the database-structure, importing data, editing data is now simple with this nice and convenient program. For designers with only a basic grasp of databases, this program is the way to go to make you independent of SQL gurus.

The program makes working with MySQL easy without hiding the language from the user. An editor is built-in, so even working with SQL-commands or scripts has been made convenient.

Screenshoots

Create and administer MySQL databases with ease

This all-in-one tool will help you create, manage and edit MySQL databases. One intuitive interface for all tasks. Supports all releases of MySQL from 4.02 and all of the latest MySQL features including views, triggers, stored procedures and functions as well as InnoDB foreign keys.

Defining and managing the database-structure, importing data, editing data is now simple with this nice and convenient program. For designers with only a basic grasp of databases, this program is the way to go to make you independent of SQL gurus.

The program makes working with MySQL easy without hiding the language from the user. An editor is built-in, so even working with SQL-commands or scripts has been made convenient.

EngInSite Client for MySQL for Developers

EngInSite Client for MySQL is designed to help PHP and Perl developers to concentrate on there business tasks - not tedious details that poison programmers life.

• Very fast retrieval of data
• Manage foreign key relationships
• Fully InnoDB compliant
• Connection and MySQL service manager
• Syntax-highlighting and Intellisense
• Save your commonly used SQL scripts in a personal folder with a click of mouse
• View advanced table properties, such as Type, Charset, Comment, Key_Length...
• Monitor variables/processes/status
• View your results in GRID / TEXT mode
• Graphical Query Builder
• Full triggers support in MySQL 5 (FILE privileges assumed)
• SQL history navigator
• User defined variable types

EngInSite Client for MySQL for Administrators

If you administer MySQL database you know it is all about data. See you data, edit your data, backup your data.

• Creating/Dropping databases
• Creating/Dropping/Altering tables
• Support for all MySQL table handlers
• Support for all field types (including BLOBs)
• Creating/Dropping indexes
• Foreign Key Management for InnoDB tables
• Powerful user manager for administering users and privileges
• Powerful blob viewer/editor: edit BLOBs with Bitmap/GIF/JPEG-support
• Export table structure and data into SQL-scripts
• Change table-types to ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB
• Flush Host / Logs / Privileges / Tables
• Diagnostics tools: check, optimize, repair, analyze
• Data Synchronization
• Structure Synchronization
• Miscellaneous HTML reports
• Charsets and collations support for databases and tables
• Views and stored procedures support in MySQL 5
• Data transfer between connections
• Various report generators

Unique Features

• Client for MySQL demonstrates a list of all available triggers for the given table. Most recent versions of MySQL do not have a command for that so we support internal storage for the MySQL trigger statements
• Convenient interface for changing Local and Global variables
• Full support for user privileges on tables

Client for MySQL system requirements:
Windows 2000 or later
256 MB of RAM
12 MB of free disk space