A Lightweight MySQL Manager

If you own a website, chances are that you need to use a database to run many site operations. For the most part, people use MySQL.

Most hosts offer a solution to manage your database. A common choice for this is phpMyAdmin. But, for many, phpMyAdmin can be slow or feel bloated on slower connections.

Then, there is the group of people who aren't offered the luxury of phpMyAdmin or even SSH. There is no way to access the database unless you install your own software.

I was one of those unlucky people working on an unnamed server without a MySQL management area. At first, I tried to install phpMyAdmin. While powerful, it is a massive download and takes a lot of configuration to get working.

I googled for a PHP MySQL manager. One of the results that I got was a sweet little app called tinyMy.

tinyMy MySQL Management Interface

Installation was simple. All I had to do was upload the file. (If your MySQL server is not 'localhost', you will have to change that before you upload.)

The front page greets you with a simple login box. I typed in my database username and password, and it instantly opened and showed all of my databases. I clicked on a database and table, and it listed the structure and contents. This was the perfect lightweight solution I needed.

The only caveat with the script is the fact that there is no GUI interface for managing tables and fields, only to view. You will need to know MySQL to manage the database, but if you have the MySQL documentation ready it should not be a problem.
If you are a MySQL user who needs a way to manage your databases from the web, then this application is perfect for you. At 7 KB, how can you go wrong?

Avatar for jacob Jacob Peddicord - http://jacob.peddicord.net/

Jacob is a web developer, student, and programmer from Ohio. He is a staff member at the Ubuntu Forums and is most likely a fanboy of the distribution. He loves to write in code and words, play video games, and rant about topics most would have abandoned long ago. Jacob uses GNOME and is never seen running stable software, much to the demise of his laptop.

Home » Articles »

Discussion: A Lightweight MySQL Manager

  1. Nick (guest)

    # Posted on 05 April 2007 at 11:11 PM

    I <strong>LOVE</strong> this program. Its so simplistic, but works so well. I'm on broadband and PHPmyadmin is still slow at times. This program is great because it loads so quickly (and I enjoy doing things the fun way!)

  2. matthew (guest)

    # Posted on 19 August 2007 at 08:19 AM

    Thanks for the suggestion/link. This is a cool little program.

  3. Oleg Burlaca (guest)

    # Posted on 01 May 2009 at 09:04 PM

    You may also try AeroSQL: http://www.burlaca.com/aerosql/. AeroSQL is a free web based tool for managing MySql servers written in PHP. The key feature of the product is an intuitive management of the database content. The result of SELECTs is displayed in a grid as in traditional desktop applications.

  4. Nayan Paul (guest)

    # Posted on 09 June 2009 at 04:08 AM

    Hello Sir I have download AeroSQL [webbases mysql GUI] but can't install it... plz plz Help Me..... You can Send me nayan.paul@yahoo.com

Home » Articles » A Lightweight MySQL Manager