Five MySQL database management tools

By Jack Wallen April 18, 2012, 6:16 AM PDT

Image
1
of 9

Introduction

ntWhether 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.

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

ntPhoto: iStockphoto.com/onurdongel

MySQL command shell

ntOf 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

ntMany 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

ntMySQL 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

ntAlthough 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

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

phpMyAdmin

ntphpMyAdmin 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

ntEmma 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

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

By Jack Wallen

Jack Wallen is an award-winning writer for TechRepublic, The New Stack, and Linux New Media. He's covered a variety of topics for over twenty years and is an avid promoter of open source. For more news about Jack Wallen, visit his website jackwallen.

Account Information

Contact Jack Wallen

Your message has been sent
|
See all of Jack's content

This policy describes guidelines your organization can follow to track, process and decommission IT equipment. From the policy: SUMMARY An organization’s IT hardware inventory constitutes a significant capital investment in order to perform company operations. Because hardware represents a critical asset and often holds organizational data, it is important for the company to track each ...

Whether an infection is the result of a disgruntled employee, hardware vulnerability, software-based threat, social engineering penetration, robotic attack or human error, all organizations must be prepared to immediately respond effectively to such an issue if the corresponding damage is to be minimized. Because even the best protected networks become infected, all organizations must have ...

Every operating system should be appropriately secured, especially end user workstations which often contain or permit access to company data and upon which most employee job duties are based. To get the maximum security protection out of your Windows 10 deployments follow this checklist from TechRepublic Premium. Also included in this checklist: Security solutions Product ...