Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Open source

Five MySQL database management tools

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

Image
1
of 9

00mysql_fig.jpg
00mysql_fig.jpg
Five MySQL database management tools

Introduction

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.

n

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

n

ntPhoto: iStockphoto.com/onurdongel

Five MySQL database management tools

MySQL command shell

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.

Five MySQL database management tools

MySQL command shell

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.

Five MySQL database management tools

MySQL Workbench

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.

Five MySQL database management tools

Webmin MySQL module

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.

Five MySQL database management tools

Webmin MySQL module

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.

Five MySQL database management tools

phpMyAdmin

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.

Five MySQL database management tools

Emma

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.

Five MySQL database management tools

Emma

Emma

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

  • Open source
  • Account Information

    Share with Your Friends

    Five MySQL database management tools

    Your email has been sent

Share: Five MySQL database management tools
Image of Jack Wallen
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

TechRepublic Premium

  • TechRepublic Premium

    Best of Confluent Current 2023: The State of Data Streaming

    TechRepublic Premium was at Confluent’s Current 2023 event, held in San Jose, California, September 26-27. Our coverage of the event comprises an analysis of data streaming, interviews, the role of stream governance and a look at Apache Flink. From the download: Confluent used the Current 2023 ‘next generation of Kafka Summit’ event in San Jose ...

    Downloads
    Published:  September 27, 2023, 4:00 PM EDT Modified:  September 28, 2023, 1:00 PM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Quick Glossary: Fintech

    Fintech is a fast changing landscape that constantly introduces cutting-edge ideas and developments. TechRepublic Premium presents this quick glossary of fintech terms and concepts to help you understand technological breakthroughs and make educated decisions. From the glossary: DECENTRALIZED FINANCE Often referred to as DeFi, this utilizes emerging technology to remove third parties and central financial ...

    Downloads
    Published:  September 27, 2023, 4:00 PM EDT Modified:  September 28, 2023, 8:52 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Anti-Money Laundering Policy

    Money laundering poses a detrimental impact on businesses and the economy as a whole. According to the United Nations Office on Drugs and Crimes, the amount of money laundered around the world in a single year is presumed to be 2–5% of global GDP, which is roughly $800 billion to $2 trillion. The purpose of ...

    Downloads
    Published:  September 27, 2023, 4:00 PM EDT Modified:  September 28, 2023, 9:14 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Hiring Kit: Video Game Audio Engineer

    Modern video games rely on a cornucopia of sounds to engage and engross players. Whether it is ambient sound to set the mood, music to invoke a feeling or dialog to tell the story, sound is vital to the immersive experience of a video game. The individual responsible for meshing all those disparate sounds together ...

    Published:  September 27, 2023, 4:00 PM EDT Modified:  September 28, 2023, 10:00 AM EDT Read More See more TechRepublic Premium articles

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice