Open Source

Five MySQL database management tools

By // April 18, 2012, 10:51 AM PST // jlwallen

Image 1 of 11

  • Introduction

    Whether you like it or hate it, you may have to deal with MySQL at some point. A lot of users think the only way to manage those databases is from the MySQL shell within a terminal. Yes, that's one way. But there are also several tools available that can help you manage the MySQL databases. Let's take a look at five of them.

    Note: If you'd prefer to view this information as a blog post, check out this entry in our Five Apps blog.

    Photo: iStockphoto.com/onurdongel

  • MySQL command shell

    Of course we should start with the built-in command-line tool. From the MySQL command shell, you can do anything you need with your MySQL databases.

  • MySQL command shell

    Many users swear by the command shell; others are intimidated by its complex command-line syntax. But if you want sheer power, this is the tool to use.

  • MySQL Workbench

    MySQL Workbench is the king of all MySQL management tools. Whatever you need to do with your databases, this GUI tool will do it. You can even use it to connect to multiple servers.

  • MySQL Workbench

    MySQL Workbench is a MySQL administrator's dream come true. And like any good database management tool, it has a built-in query tool and command shell.

  • Webmin MySQL module

    Although not quite as powerful as the MySQL Workbench (you can work only on the databases local to the server), the MySQL Webmin module allows you do handle nearly any task on your databases -- all through your Web browser.

  • Webmin MySQL module

    The Webmin MySQL module makes it easy to manage your databases on one server from anywhere that has access to the machine.

  • phpMyAdmin

    phpMyAdmin is a favorite of many database admins. It's a PHP-driven tool and handles every aspect of managing a MySQL database server.

  • phpMyAdmin

    phpMyAdmin has a user-friendly interface and makes the tasks of creating and managing databases simple. It also allows for the execution of MySQL commands from within the interface.

  • Emma

    Emma is another GUI tool for the management of MySQL databases. Although not as feature-rich as MySQL Workbench, it does a great job of offering a user-friendly interface for database management on a particular machine.

  • Emma

    One of Emma's handiest features is the ability to export query results into a csv list file.

Introduction

Whether you like it or hate it, you may have to deal with MySQL at some point. A lot of users think the only way to manage those databases is from the MySQL shell within a terminal. Yes, that's one way. But there are also several tools available that can help you manage the MySQL databases. Let's take a look at five of them.

Note: If you'd prefer to view this information as a blog post, check out this entry in our Five Apps blog.

Photo: iStockphoto.com/onurdongel

Related Topics:

Open Source Software Security Developer Enterprise Software Innovation

By Jack Wallen

Jack Wallen is an award-winning writer for TechRepublic and Linux.com. He’s an avid promoter of open source and the voice of The Android Expert. For more news about Jack Wallen, visit his website jackwallen.com.