mysql admin and development tools

In the overview below we present some of the most use­ful and most pop­u­lar MySQL Admin and Devel­op­ment Tools for Mac, Win­dows and Linux, for begin­ners and for pro­fes­sion­als. Among other tools we fea­ture php­MyAd­min, MySQL Work­bench, Hei­diSQL and Sequel­Pro. Please let us know if some use­ful MySQL-tool is miss­ing in the list by com­ment­ing upon this article.

You may be inter­ested in the fol­low­ing related posts:

• 8 Use­ful Word­Press SQL Hacks
• Cheat Sheet Round-Up: Ajax, CSS, MySQL, Ruby…

MySQL Work­bench (Win, Linux, Mac)

MySQL Work­bench
This appli­ca­tion is a fully fea­tured visual data­base design pack­age that includes data­base design, mod­el­ing, cre­ation and main­te­nance bun­dled into a sin­gle envi­ron­ment for the MySQL data­base sys­tem. The free ver­sion is the Com­mu­nity Edi­tion, which is loaded with fea­tures that will meet almost all your require­ments. If you feel adven­tur­ous you could always go for the com­mer­cial ver­sion (Stan­dard Edition).

• Help and Sup­port
  MySQL Work­bench Help
• Down­load
  Select your down­load version

Hei­diSQL – MySQL made easy (Win, Linux)

Heidi SQL
Heidi SQL is light­weight and fast with a flex­i­ble inter­face, it allows you to browse and edit your data­bases data­bases, man­age tables, view and edit records, man­age user-privileges, import data from text files, run SQL queries, syn­chro­nize tables between two data­bases and export selected tables to other data­bases or SQL scripts, and all this from an intu­itive Win­dows interface.

• Help and Sup­port
  Heidi SQL Forums
• Down­load
  jHeidi Alpha 4 download

You can also down­load a small app for the iPhone called jHeidi Mobi, whicht is the only appli­ca­tion to offer Ora­cle and MySQL access in a mobile appli­ca­tion. jHeidi Mobi Down­load Page

Aqua Data Stu­dio (Win, Linux, OS X, Solaris)

Aqua Data Stu­dio
This com­plete IDE, has four major areas of func­tion­al­ity: Data­base query and admin­is­tra­tion tools; a suite of com­pare tools for data­bases, source con­trol and file sys­tems; inte­grated source con­trol client for Sub­ver­sion (SVN) and CVS; and a pow­er­ful data­base mod­eler. The Stu­dio has a sin­gle con­sis­tent inter­face to all major rela­tional data­bases, this allows the devel­oper to simul­ta­ne­ously tackle sev­eral tasks from within a sin­gle application.

• Help and Sup­port
  Aqua Data Stu­dio Support
• Down­load
  Aqua Data Stu­dio Down­loads Page

php­MyAd­min

php­MyAd­min
This very pop­u­lar, fea­ture rich and easy to use free tool, writ­ten in PHP (obviusly), has been built to han­dle the full admin­is­tra­tion of MySQL. It can cre­ate and drop data­bases, create/drop/alter tables, delete/edit/add fields, exe­cute any SQL state­ment, man­age users and per­mis­sions, and man­age keys on fields. A nice fea­ture from this leg­endary tool is that you can down­load and change the theme (not exactly a mon­u­men­tal fea­ture, but a unique fea­ture), down­load themes here: php­MyAd­min Themes (remem­ber themes are ver­sion specific).

• Help and Sup­port
  php­MyAd­min Support
• Docs
  php­MyAd­min Docs
• Down­load
  php­MyAd­min Down­loads Page

SQLyog MySQL GUI (Win)

SQLyog
SQLyog is another pop­u­lar SQL man­age­ment tool that has a cou­ple of use­ful fea­tures such as visual schema designer, visual query builder, intel­li­gent code com­ple­tion and a data / struc­ture syn­chro­niza­tion. It sup­port HTTP / HTTPs / SSH tun­nel­ing and SSL con­nec­tions. You can also spec­ify a job man­ager, define a sched­uled data­base backup and use a noti­fi­ca­tion ser­vice to be reminded when some jobs are fin­ished. There is a free Com­mu­nity ver­sion and a com­mer­cial Enter­prise edi­tion. You may also use MONyog, a MySQL Mon­i­tor and Advisor.

• Help and Sup­port
  SQLyog Forum
• FAQ
  SQLyog FAQ
• Down­load
  SQLyog Down­loads Page

MySQL-Front (Win)

MYSQL Front
This graph­i­cal GUI for the MySQL data­base, is a “real” appli­ca­tion, it can offer a more refined user-interface than is pos­si­ble with sys­tems built on PHP and HTML. Response is imme­di­ate, as there is no delay of reload­ing HTML-pages. If your provider allows it, MySQL-Front can make direct con­tact with the data­base. Oth­er­wise, only one small script needs to be installed on the pub­lish­ing web­site. Login infor­ma­tion are stored on your hard disk, so you no longer have to log on to dif­fer­ent web interfaces.

• Help and Sup­port
  MYSQL Front Forum
• Down­load
  MYSQL Front Down­loads Page

Sequel Pro (Mac OS X)

Sequel Pro
This MAC OSX data­base man­age­ment app gives you direct access to your MySQL data­bases on local and remote servers with sup­port for import­ing and export­ing data from pop­u­lar files includ­ing SQL, CSV and XML. Sequel Pro started as a fork of the open source CocoaMySQL project. It is the self pro­claimed “Best Look­ing MySQL Data­base Man­age­ment App for the Mac OS X“, going by the screen­shot below they wouldn’t be wrong, it is sleek and cool.

• Help and Sup­port
  Sequel Pro Support
• Down­load
  Sequel Pro Down­loads Page

SQL Buddy (Web-App)

SQL Buddy
This cool light­weight ajax pow­ered data­base man­age­ment tool is amaz­ing. It is very, very easy to install, unzip the folder to your server and thats it. As for upgrad­ing, delete the older ver­sion and replace with the new ver­sion, sim­ple. Being pow­ered by Ajax, it is browser friendly so you can use nor­mal brows­ing actions like “book­mark”, “back” and “refresh”. There is also a use­ful range of key­board short­cuts, which you can view here: SQL Buddy Key­board Short­cuts.

• Help and Sup­port
  SQL Buddy Support
• Down­load
  SQL Buddy Down­loads Page

EMS SQL Man­ager (Win)

EMS SQL Man­ager
EMS SQL Man­ager is a fairly high per­for­mance tool for data­base admin­is­tra­tion and devel­op­ment. Fea­tures include MySQL trig­gers, views, stored pro­ce­dures and func­tions, Inn­oDB for­eign keys, it allows you to create/edit all MySQL data­base objects, design data­bases visu­ally, run SQL scripts, import and export data­base data, man­age users and their priv­i­leges and has many other use­ful fea­tures. There is a com­mer­cial ver­sion, but down­load the free ver­sion, its fairly pow­er­ful and offers plenty of features.

• Help and Sup­port
  EMS SQL Man­ager Support
• Down­load
  EMS SQL Man­ager Down­loads Page

Nav­i­cat Lite MySQL Admin Tool (Win, OS X, Linux)

Nav­i­cat Lite MySQL Admin Tool
Nav­i­cat is a fast, reli­able and pop­u­lar (mil­lions of down­loads) Data­base Admin­is­tra­tion tool purpose-built for sim­pli­fy­ing data­base man­age­ment and reduc­ing admin­is­tra­tive costs. Designed to meet the needs of data­base admin­is­tra­tors, devel­op­ers, and small and medium busi­nesses, Nav­i­cat is built with an intu­itive GUI which lets you cre­ate, orga­nize, access and share infor­ma­tion in a secure and easy way. Nav­i­cat Lite is avail­able as a free down­load only for non-commercial customers.

• Help and Sup­port
  Nav­i­cat Support
• Down­load
  Nav­i­cat Down­loads Page

Dream­Coder for MySQL (Win)

Dream­Coder for MySQL
Dream­Coder works with all MySQL ver­sions from 3.23 to 6.0 and it sup­ports all MySQL fea­tures includ­ing tables, views, pro­ce­dures, func­tions, trig­gers, Inn­oDB Tables, for­eign keys , UDFS, BLOB Types, etc. It also includes the most advanced options for data manip­u­la­tion, build queries visu­ally, exe­cute queries, script exe­cu­tion, reports gen­er­a­tion, data­base mon­i­tor­ing and export and import data to/from most pop­u­lar file for­mats. Dream­Coder for MySQL is easy to use for the novice MySQL user and is pow­er­ful enough for any expert user.

• Help and Sup­port
  Dream­Coder Support
• Down­load
  Dream­Coder Down­loads Page

Toad MySQL (Win)

Toad MySQL
Toad for MySQL is a data­base devel­op­ment and admin­is­tra­tion tool that pro­vides pro­duc­tiv­ity fea­tures for rapidly cre­at­ing and exe­cut­ing queries and man­ag­ing com­plex data­base sys­tems. It pro­vides util­i­ties to com­pare, extract and search for objects, man­age projects, import/export data and admin­is­ter the data­base. Changes to the inter­face recently has been the the intro­duc­tion of the “Tabbed Doc­u­ment Inter­face”, this means you can view a fully max­i­mized win­dow with­out the need for you to con­stantly resize, arrange, or tile the windows.

• Help and Sup­port
  Toad MySQL Support
• Down­load
  Toad MySQL Down­loads Page

DB Tools Man­ager Pro­fes­sional (Win)

DB Tools Man­ager Pro­fes­sional
DBMan­ager is a fairly pow­er­ful appli­ca­tion data man­age­ment data man­age­ment. With builtin sup­port for MySQL, Post­greSQL, Interbase/Firebird, SQLite, DBF tables, MSAc­cess, MSSQL Server, Sybase, Ora­cle and ODBC data­base engines, mak­ing it one of the most advanced data­base appli­ca­tion. The free edi­tion (Stan­dard Edi­tion) has a min­imun set of fea­tures that makes it ideal for new data­base users to per­form basic data­base man­age­ment, you can use this for non com­mer­cial use.

• Help and Sup­port
  DB Tools Man­ager Forum
• Down­load
  DB Tools Man­ager Down­loads Page

MyCon – MySQL GUI (Win)

MyCon – MySQL GUI
MyCon is an extremely pow­er­ful win­dows based graph­i­cal user inter­face, MySQL GUI, for admin­is­ter­ing and work­ing with MySQL server data­bases. This easy to use MySQL GUI front-end client includes all the func­tion­al­ity and tools you will need to be pro­duc­tive in MySQL as a DBA, devel­oper, man­ager, report writer or a gen­eral end-user.

• Help and Sup­port
  MyCon – MySQL GUI Forum
• Down­load
  Free MyCon Down­loads Page

MyDB Stu­dio (Win)

MyDB Stu­dio
MyDB Stu­dio is a com­plete col­lec­tion of pow­er­ful tools for MySQL Server admin­is­tra­tion. MyDB Stu­dio (free­ware) is designed for MySQL devel­op­ers and admin­is­tra­tors to rapidly man­age, cre­ate and exe­cute queries and develop SQL and Php code more effi­ciently. Keep an eye out for the upcom­ing Adobe Air ver­sion of MyDB Stu­dio, that will be cool.

• Help and Sup­port
  MyDB Stu­dio FAQ
• Down­load
  MyDB Stu­dio Down­loads Page

MySQL Sidu (Win)

MySQL Sidu
MySQL Sidu is a FREE MySQL client that works via your web browser, it is sim­ple, intu­itive and an easy data­base tool to use. Sidu is not as pow­er­ful as other sim­il­iar tools but packs enough punch to merit its place in this list, its fea­tures may be lim­ited but it does do exactly what the name says (Sidu stands for Select Insert Delete Update).
You can also use a Fire­fox Exten­sion in con­junc­tion with Sidu that enables you to insert data from text fields & textar­eas in a web­page. View the details here: Fire­fox addon for MySQL Sidu.

• Help and Sup­port
  MySQL Sidu Support
• Down­load
  MySQL Sidu Down­loads Page

apache friends – xampp (Win, Mac, Linux, Solaris)

apache friends – xampp
It’s not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl. XAMPP is an easy to install Apache dis­tri­b­u­tion con­tain­ing MySQL, PHP and Perl. It is really very easy to install and to use – just down­load, extract and start.

• Help and Sup­port
  xampp Sup­port
• Down­load
  xampp Down­loads Page

Fur­ther MySQL Links

Finally, here are some fur­ther gen­eral ref­er­ences to MySQL and MySQL-related resources.

• MySQL Home­page
• MySQL Devel­oper Zone
• MySQL Down­loads
• MySQL Forums
• MySQL on Wikipedia
• MySQL Cheat Sheets

Via: smashingmagazine.com/

Fonte:http://speckyboy.com/