A Collection Of MySQL Administration Tools

Posted in Tools | On 6th December 2009 | 6 Comments

MySQL is an opensource solution for database management, it is one of the most popular options for many developers as it’s free, simple to use and very effective in serving its purpose.

To work on your MySQL database you will benefit from using some kind of “front end” to allow you to view and edit the database, you can do this in a variety of ways with a good number of tools.

Here I have listed some solutions for Windows, Mac OSX, Linux and some online applications, all the resources below are opensource or free to use.

Cross Platform Solutions

Lita

lita

SQuirreL SQL

squ

Windows Solutions

MyDB Studio

mydb

Toad for MySQL

toad

Mac OSX Solutions

Sequel Pro

seqpro

SQLGrinder

grind

Linux Solutions

HeidiSQL

heidi

MySQL Workbench

workb

Online Solutions

MySql Lite Administrator

lite

phpMyAdmin

phpmy

SQL Buddy

sqlbud

McBonio

McBonio is a full time web designer, blogger and general web lurker. He runs Tropica Web Design, which is a web agency based in Liverpool, UK. You can also catch McBonio at Twitter: @mcbonio

Visit McBonio's website

Related Posts

Like this post? Share it!

6 Comments

  • Keloran
    December 7, 2009

    You missed Querious (OSX) unless your criteria was free

    sequel pro doesnt have user controls, where as Querious does

  • McBonio
    December 7, 2009

    Querious is a very good tool too thanks Keloran.

    The criteria was free and open source tools, but the recommendation is most appreciated :)

  • zeruch
    December 7, 2009

    HeidiSQL is a win32 executable actually, not a Linux package. It is FOSS however (hence the ability to port it is readily there), and works quite well.

  • McBonio
    December 7, 2009

    Thanks zeruch, I believe it works well on Linux with Wine also :)

Trackbacks