MySQL Administration Tools

Screenshot of PhpMyAdmin

MySQL Administration Tools

MySQL is a great database server and there are a few database administration tools that I have used which I would like to share with you. These all run on Windows and can run multiple commands at once be able to do schema or data import and export. See below for my usable, functional MySQL admin tools. MySQL recently released version 5.2 of the workbench software which is fantastic as a standalone application. I usually recommend phpmyadmin for web based administration.

1) PhpMyAdmin

phpMyAdmin is a free software tool written in PHP and offers simple remote administration of MySQL over the World Wide Web. It supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statements.

2) MySQL Workbench

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.

MySQL Workbench

3) Navicat

Navicat offersa clear interface to easily manage your MySQL databases with a simple to use GUI Tool. You can quickly view elements like tables, stored procedures, events, queries and reports. Navicat supports all MySQL versions and lets you easily import and export your data.

Navicat Screenshot

4) SQLyog

The SQLyog GUI is a powerful MySQL manager and admin tool, and combines the features of MySQL Query Browser, Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools in a single intuitive interface. You can download a 30day trial but a single user license is around $130.

Comments 3 comments

pork22 profile image

pork22 6 years ago

I use myphpadmin because it is installed where I host my sites.


tomanderson45 3 years ago

You can check one more tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-ov... 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.


tomanderson45 3 years ago

You can check one more tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-ov... 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working