MYSQL ADMIN AND DEVELOPMENT TOOLS ROUND UP
The many renouned and many appropriate open source database is MySQL. Simple as that. It is consistently fast , reliabile and very, unequivocally easy to use. One of MySQLs main facilities is the cross-platform support, it will run on roughly all handling systems, together with Windows, OSX, Linux and many more. So, MySQL is the many appropriate database, and we all have make have make make make make make make make make make use of of of of of of of of of of of of it. The subject right away is which is the many appropriate MySQL Admin and Development Tool?
In the ubiquitous outlook next we benefaction a little of the many utilitarian and many renouned MySQL Admin and Development Tools for Mac, Windows and Linux, for beginners and for professionals. Among alternative pick up we underline phpMyAdmin, MySQL Workbench, HeidiSQL and SequelPro. Please let us know if a little utilitarian MySQL-tool is blank in the list by commenting on this article.
You might be meddlesome in the following associated posts:
MySQL Workbench (Win, Linux, Mac)
MySQL Workbench
This focus is a entirely featured visible database design package which includes database design, modeling, origination and upkeep bundled in to a singular sourroundings for the MySQL database system. The free chronicle is the Community Edition, which is commissioned with facilities which will encounter roughly all your requirements. If you feel brave you could regularly go for the blurb chronicle (Standard Edition).
- Help and Support
MySQL Workbench Help - Download
Select your download version
HeidiSQL - MySQL done easy (Win, Linux)
Heidi SQL
Heidi SQL is lightweight and fast with a stretchable interface, it allows you to crop and edit your databases databases, conduct tables, perspective and edit records, conduct user-privileges, import interpretation from content files, run SQL queries, synchronize tables in between dual databases and trade comparison tables to alternative databases or SQL scripts, and all this from an discerning Windows interface.
- Help and Support
Heidi SQL Forums - Download
jHeidi Alpha 4 download
You can additionally download a small app for the iPhone called jHeidi Mobi, whicht is the usually focus to suggest Oracle and MySQL entrance in a mobile application. jHeidi Mobi Download Page
Aqua Data Studio (Win, Linux, OS X, Solaris)
Aqua Data Studio
This finish IDE, has 4 vital areas of functionality: Database question and administration department department department department department tools; a apartment of review pick up for databases, source carry out and record systems; integrated source carry out customer for Subversion (SVN) and CVS; and a absolute database modeler. The Studio has a singular unchanging interface to all vital relational databases, this allows the developer to concurrently plunge into multiform tasks from inside of a singular application.
- Help and Support
Aqua Data Studio Support - Download
Aqua Data Studio Downloads Page
phpMyAdmin
phpMyAdmin
This unequivocally popular, underline abounding and easy to have make have make make make make make make make make make use of of of of of of of of of of of of free tool, created in PHP (obviusly), has been built to hoop the full administration department department department department department of MySQL. It can emanate and dump databases, create/drop/alter tables, delete/edit/add fields, govern any SQL statement, conduct users and permissions, and conduct keys on fields. A good underline from this mythological apparatus is which you can download and shift the thesis (not only a staggering feature, but a singular feature), download themes here: phpMyAdmin Themes (remember themes have been chronicle specific).
- Help and Support
phpMyAdmin Support - Docs
phpMyAdmin Docs - Download
phpMyAdmin Downloads Page
MySQL-Front (Win)
MYSQL Front
This graphical GUI for the MySQL database, is a “real” application, it can suggest a some-more polished user-interface than is probable with systems built on PHP and HTML. Response is immediate, as there is no check of reloading HTML-pages. If your provider allows it, MySQL-Front can have approach hit with the database. Otherwise, usually one small book needs to be commissioned on the book website. Login inform have been stored on your tough disk, so you no longer have to log on to opposite web interfaces.
- Help and Support
MYSQL Front Forum - Download
MYSQL Front Downloads Page
Sequel Pro (Mac OS X)
Sequel Pro
This MAC OSX database government app gives you approach entrance to your MySQL databases on internal and remote servers with await for importing and exporting interpretation from renouned files together with SQL, CSV and XML. Sequel Pro proposed as a flare of the open source CocoaMySQL project. It is the self admitted “Best Looking MySQL Database Management App for the Mac OS X“, going by the screenshot next they wouldn’t be wrong, it is neat and cool.
- Help and Support
Sequel Pro Support - Download
Sequel Pro Downloads Page
SQL Buddy (Web-App)
SQL Buddy
This cool lightweight ajax powered database government apparatus is amazing. It is very, unequivocally easy to install, unzip the printed matter to your server and thats it. As for upgrading, undo the comparison chronicle and reinstate with the brand brand new version, simple. Being powered by Ajax, it is browser accessible so you can have make have make make make make make make make make make use of of of of of of of of of of of of normal browsing actions similar to “bookmark”, “back” and “refresh”. There is additionally a utilitarian operation of set of keys shortcuts, which you can perspective here: SQL Buddy Keyboard Shortcuts.
- Help and Support
SQL Buddy Support - Download
SQL Buddy Downloads Page
EMS SQL Manager (Win)
EMS SQL Manager
EMS SQL Manager is a sincerely high opening apparatus for database administration department department department department department and development. Features embody MySQL triggers, views, stored procedures and functions, InnoDB unfamiliar keys, it allows you to create/edit all MySQL database objects, design databases visually, run SQL scripts, import and trade database data, conduct users and their privileges and has many alternative utilitarian features. There is a blurb version, but download the free version, the sincerely absolute and offers copiousness of features.
- Help and Support
EMS SQL Manager Support - Download
EMS SQL Manager Downloads Page
Navicat Lite MySQL Admin Tool (Win, OS X, Linux)
Navicat Lite MySQL Admin Tool
Navicat is a fast, arguable and renouned (millions of downloads) Database Administration apparatus purpose-built for simplifying database government and shortening executive costs. Designed to encounter the needs of database administrators, developers, and small and middle businesses, Navicat is built with an discerning GUI which lets you create, organize, entrance and share inform in a secure and easy way. Navicat Lite is accessible as a free download usually for non-commercial customers.
- Help and Support
Navicat Support - Download
Navicat Downloads Page
DreamCoder for MySQL (Win)
DreamCoder for MySQL
DreamCoder functions with all MySQL versions from 3.23 to 6.0 and it supports all MySQL facilities together with tables, views, procedures, functions, triggers, InnoDB Tables, unfamiliar keys , UDFS, BLOB Types, etc. It additionally includes the many modernized options for interpretation manipulation, set up queries visually, govern queries, book execution, reports generation, database monitoring and trade and import interpretation to/from many renouned record formats. DreamCoder for MySQL is easy to have make have make make make make make make make make make use of of of of of of of of of of of of for the beginner MySQL user and is absolute sufficient for any consultant user.
- Help and Support
DreamCoder Support - Download
DreamCoder Downloads Page
Toad MySQL (Win)
Toad MySQL
Toad for MySQL is a database growth and administration department department department department department apparatus which provides capability facilities for fast formulating and executing queries and handling formidable database systems. It provides utilities to compare, remove and poke for objects, conduct projects, import/export interpretation and discharge the database. Changes to the interface not long ago has been the the key of the “Tabbed Document Interface”, this equates to you can perspective a entirely maximized window but the need for you to all the time resize, arrange, or tile the windows.
- Help and Support
Toad MySQL Support - Download
Toad MySQL Downloads Page
DB Tools Manager Professional (Win)
DB Tools Manager Professional
DBManager is a sincerely absolute focus interpretation government interpretation management. With builtin await for MySQL, PostgreSQL, Interbase/Firebird, SQLite, DBF tables, MSAccess, MSSQL Server, Sybase, Oracle and ODBC database engines, creation it one of the many modernized database application. The free book (Standard Edition) has a minimun set of facilities which creates it preferred for brand brand new database users to perform elementary database management, you can have make have make make make make make make make make make use of of of of of of of of of of of of this for non blurb use.
- Help and Support
DB Tools Manager Forum - Download
DB Tools Manager Downloads Page
MyCon - MySQL GUI (Win)
MyCon - MySQL GUI
MyCon is an intensely absolute windows formed graphical user interface, MySQL GUI, for administering and operative with MySQL server databases. This easy to have make have make make make make make make make make make use of of of of of of of of of of of of MySQL GUI front-end customer includes all the functionality and pick up you will need to be prolific in MySQL as a DBA, developer, manager, inform bard or a ubiquitous end-user.
- Help and Support
MyCon - MySQL GUI Forum - Download
Free MyCon Downloads Page
MyDB Studio (Win)
MyDB Studio
MyDB Studio is a finish pick up of absolute pick up for MySQL Server administration. MyDB Studio (freeware) is written for MySQL developers and administrators to fast manage, emanate and govern queries and rise SQL and Php formula some-more efficiently. Keep an eye out for the arriving Adobe Air chronicle of MyDB Studio, which will be cool.
- Help and Support
MyDB Studio FAQ - Download
MyDB Studio Downloads Page
MySQL Sidu (Win)
MySQL Sidu
MySQL Sidu is a FREE MySQL customer which functions around your web browser, it is simple, discerning and an easy database apparatus to use. Sidu is not as absolute as alternative similiar pick up but packs sufficient punch to consequence the place in this list, the facilities might be singular but it does do only what the name says (Sidu stands for Select Insert Delete Update).
You can additionally have make have make make make make make make make make make use of of of of of of of of of of of of a Firefox Extension in and with Sidu which enables you to insert interpretation from content fields & textareas in a webpage. View the sum here: Firefox addon for MySQL Sidu.
- Help and Support
MySQL Sidu Support - Download
MySQL Sidu Downloads Page
apache friends - xampp (Win, Mac, Linux, Solaris)
apache friends - xampp
It’s not easy to implement an Apache web server and it gets harder if you wish to supplement MySQL, PHP and Perl. XAMPP is an easy to implement Apache placement containing MySQL, PHP and Perl. It is unequivocally really easy to implement and to have make have make make make make make make make make make use of of of of of of of of of of of of - only download, remove and start.
- Help and Support
xampp Support - Download
xampp Downloads Page
Further MySQL Links
Finally, here have been a little serve ubiquitous references to MySQL and MySQL-related resources.
- MySQL Homepage
- MySQL Developer Zone
- MySQL Downloads
- MySQL Forums
- MySQL on Wikipedia
- MySQL Cheat Sheets
What MySQL Admin and Development Tool Do You Use?
What MySQL Admin and Development Tools do you use?
( online surveys)
Related posts
You might be meddlesome in the following associated posts:
About the author
Paul Andrew is a freelance web designer. He is arch admin for Speckyboy - Design Magazine, a web design, web growth and striking design apparatus blog. Follow him on Twitter here: twitter.com/speckyboy.
© Paul Andrew for Smashing Magazine, 2009. |
Permalink |
8 comments |
Add to del.icio.us | Digg this | Stumble on StumbleUpon! | Tweet it! | Submit to Reddit | Forum Smashing Magazine
Read the strange post:
MySQL Admin and Development Tools Round Up
Popularity: 1% [?]
