Easy to use substitutes for phpMyAdmin

Tags: phpMyAdmin alternatives

Those who are involved in the management of MySQL administration tasks often rely on phpMyAdmin, an open source tool written in PHP. This tool will carry out a lot of tasks including creation, modification and deletion of databases, tables, fields and rows. As phpMyAdmin is written in PHP, it can be installed on webs server easily, and can be accessed from any browser without any difficulty.  Those who want to have a substitute can use tools like MonoQL, the most recently discovered alternative, enabled using Ajax. Here are a few other MySQL administration alternatives which are used by PHP web developers these days.

SQL Buddy - SQL Buddy is a widely used open source data management tool. This has a simple and efficient GUI and allows developers to easily edit their databases from the web.  SQL Buddy can be used to ‘create, modify, or drop tables, indexes, foreign key relationships, and records’. Those who want to run ‘ad hoc SQL queries’ can do the same with the help of SQL Buddy.

This powerful tool has a speedy and attractive Ajax interface. It also has multiple languages and themes, making it stand out from the crowd. As it is just 320kB, users can easily download SQL Buddy and install the tool on their PC. All that you have to do is just copy the files to your server and login using the database user ID and password.

On the whole, SQL Buddy has several advantages when compared to phpMyAdmin.

Adminer – This single 186kB file is a widely appreciated tool for managing MySQL database contents. You need not worry about any complexities in installing this tool. Simply upload the file and login. According to a leading online magazine, ‘Adminer supports MySQL, PostgreSQL, SQLite, SQL Server, and Oracle, and runs under PHP4 or PHP5’. It also offers a WordPress plugin version.

PHP Mini Admin – Web developers can also consider PHP Mini Admin. You can upload the file easily and start using by logging in. PHP Mini Admin is fast and highly functional, but the features given are limited when compared to others.

EMS SQL Manager - EMS SQL Manager is a widely used tool for administration and development of MySQL database. It works on all the commonly used MySQL versions, and supports all the most modern features used now. Users can easily create/edit all MySQL database objects, flawlessly design MySQL databases, run error free SQL scripts, import/export MySQL database data  and can do many other useful features for professional MySQL administration.

SQLyog - SQLyog is a Win32 Front End for the MySQL database administration. The program is made especially for those users who are familiar with SQL statements and need a user-friendly graphical interface to manage SQL queries. SQLyog is the creation of Webyog, a software development company based in Bangalore.

Comments and Feedback

You can check one more tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 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.

Post your Comment

Type your comment here*


Verification Code Image

Back to Main Top of Page