DbNinja

DbNinja is perfect for both developers, companies and newbies alike, allowing webmasters to manage a complex database like MySQL to be managed with a simple "one-push button" interface, compared to the over-complicated MySQL CLI.

The entire system is very user friendly, secure, and also extremely easy to install as well.

It can run on localhost installations, or on remote servers, managing both local or remote databases at the same time.

DbNinja's main role is to provide a simple interface for common MySQL tables management, but it can also prove as a crucial asset when migrating databases between servers.

Features:

• Manage multiple DB hosts
• Manage multiple databases
• Manage database tables
• Manage events
• Manage indices
• Manage foreign keys
• Manage triggers
• Manage DB user accounts
• Manage user privileges and grants
• Manage active server connections
• Database repair tool
• Optimize DB tables
• Database back-up utility
• Database restore function
• Export data into files
• Customize and edit procedures, functions and views
• Edit system values, variables and properties
• Save favorite queries
• Multilingual interface
• Tabbed-based interface
• Database tree navigation menu
• Context menus
• Drag and drop actions
• Query editor
• Syntax highlighting

What is new in this release:

• New Features:
• Added row numbering in query result
• Allow to export query data prior to running the query
• Added show/hide query log button to top menu
• Bug Fixes:
• Stored procedures with enum arguments do not parse correctly
• Table data import problems with files containing over a few tens of thousand records
• Export to Script and Export Data sometimes failing if PHP has no multibyte extension installed
• More informative error messages

What is new in version 3.2.5:

• New Features:
• View database object details: amount of rows in tables, table size, etc
• Bug Fixes:
• Paging issues in multi result with multiple pages
• Execution errors in scripts with certain stored routines
• Bottom scrollbar in query editor not working after opening query log

What is new in version 3.2.4:

• Bug Fixes:
• Views with UNION don't show correctly in the editor.
• Execution of a script that's larger than 'max_allowed_packet' doesn't produce an error message.
• Request time out setting not affecting execution of scripts.

Requirements:

• PHP 5.3 or higher
• MySQL 4.1 or higher