MySQL is a popular database system used in the backend of a huge number of web applications. Just about every database driven PHP application I have seen has MySQL working alongside it. There are various tools available (usually provided by your web host) for managing MySQL databases online (phpMyAdmin for instance). I have found that having a desktop manager can be very useful. I’ve found it particularly useful when I need to manually edit data within a range of tables and records.
The following tools are worth checking out if a desktop MySQL manager is what you want:
OPEN SOURCE
- HeidiSQL (formally SQLFront — an old favorite of mine)
- generate nice SQL-exports
- synchronize tables between two databases
- manage user-privileges
- import text-files
- export table-data as CSV, HTML and XML
- browse and edit table-data using a comfortable grid
- batch-insert ascii or binary files into tables
- write queries with syntax-highlighting (next version will have also code-completion)
- monitor and kill client-processes
- and much more
- MySQL Administrator and MySQL Query Browser (from the makers of MySQL)
Avaialble for Mac, Windows, and Linus
I find the Heidi system to be easier to use
HeidiSQL is an easy-to-use interface and a “working-horse” for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.
With HeidiSQL you will also be able to
COMMERCIAL APPLICATIONS
- Navicat — avaialble for Mac, Windows, and Linux
- EMS SQL Manager for MySQL
0 Responses to “MySQL Desktop Management Tools”