Almost all LAMP Developers start their careers with the use of PHPMyAdmin which is a reasonable MySQL client to begin with but I think PHPMyAdmin hasn’t evolved with the same pace as rest of the Web Development techniques have.
MyWebSQL on the other hand is as robust as PHPMyAdmin with a user friendly interface and almost everything a Web 2.0 Application needs. Moreover its open source too, free to use with plenty of support for users from the development team.
I will list down some of the prominent features of MyWebSQL which make it stand out, hoping that this review will help developers find a decent MySQL Web client easily.
- Speed: MyWebSQL is substantially quicker than PHPMyAdmin. The difference is so noticeable that I had to mention it as the first advantage over PHPMyAdmin. It uses Asynchronous (Ajax) calls for executing the queries which also adds up to the speed.
- Simplicity & Interactivity: The user interface is very friendly with a decent, minimalist and light design. This also makes it easier for newbies to have a better experience. The buttons and menus are very much like any OS, so there is no learning curve for the user. And I love its right click functionality, being a Windows user I am very much used to the right click functionality when I am unable to find the required operation.
- Easy to Setup: It is very simple to setup on your hosted or local web server without any additional complex configuration of any sort. All it needs is PHP 5 and MySQL (versions 4 and 5 are both supported). The development team has recently added the support for SQLite as well.
- Themes & Languages: Though it is a tool to help in web development yet the developers have given multiple themes to select from if the default theme is not comfortable for your eyes. The basic package comes with 6 themes for now, but new themes can be created using jQuery UI base themes.Along with themes, it also comes in 39 different languages to choose from.
[If you are a developer and can help with translation into any language, you are more than welcome to send a request to the developers on the project website]
- Blazing fast Query Execution: MyWebSQL uses asynchronous query execution, making the process real quick and there are no waiting times for the page to reload and get the results. Moreover it has a panel at the bottom where you can write your query and see the results in the top panel. Making it look similar to any MySQL client installed on your desktop.
- Quick Record Editing: This is one of the neatest and unique feature of MyWebSQL. Records editing is really quick and simple, you can edit the records by double clicking on them. No need to browse to another page for editing records. And multiple edits can be saved with a single click, or you can simply generate SQL queries for your editing session and execute them manually after inspection.
- WYSIWYG Table Editor: The table creator and editor are completely WYSIWYG, so you can create or edit your tables in grid format, and it will generate the right queries for you to create or alter the tables as necessary.
- Syntax Highlighting:The Query Editor in MyWebSQL gives a very good syntax highlighting making the SQL queries more readable. Unlike the simple text box version in PHPMyAdmin. If you are a developer with basic knowledge of PHP, you can also pick any browser based code editor and integrate it with MyWebSQL easily.
- Multitasking:Yes, MyWebSQL supports multitasking, no need to open different tabs for seeing results of different queries. You can do all of it in one single tab under different interfaces within MyWebSQL. Tools and utilities available in the interface open up in separate dialogs, so you can multitask easily without losing focus from your queries.
- Import / Export & Multiple Servers:MyWebSQL supports importing and exporting databases, tables and results to and from different formats. The export has a special feature where you can export large databases without having to worry about the PHP Memory limits, which is an issue with PHPMyAdmin. MyWebSQL also supports connections to multiple Database servers.
- Customizable Sections: Different sections on the UI can be hidden and shown as per need. This gives the power to see only the sections that are needed. Moreover, next time you open the interface, your settings are preserved!
- Common Tools: Powerful Tools:Common database management tools like Process Manager, User and Permission Manager, Table checker/optimizer, Database Text Search, Table Index Manager etc. are included in the application.
The above list of impressive features have made MyWebSQL my favorite MySQL client. If you are fed up of your MySQL Client then MyWebSQL is going to be a good choice for you. You can check the Online Demo and decide for yourself. You can also send your feature request and bug reports, as the development team is pretty active in responding to your queries.
19 replies on “A PHPMyAdmin alternative with a user friendly interface”
To the author: *which* phpMyAdmin version did you try? The upcoming version 3.5.0 has a number of improvements.
Hi @49db3b833015ec0ecbd941658c336062:disqus ,
Yes I tried the new theme and syntax highlighting, but apart from that the interface is still the same. There are different features in here which PHPMyAdmin hasn’t worked on even after being probably the most used web client for MySQL.
I would suggest you to give MyWebSQL a try, I hope you will feel the difference as I did
Hi Umair Jabbar,
Did you try the development version (future 3.5.0), available as a snapshot at http://www.phpmyadmin.net/home_page/downloads.php ? There are many operations that were Ajaxified and a new grid-editing feature.
Hey @49db3b833015ec0ecbd941658c336062:disqus ,
I have just tried their latest demo once again. http://demo.phpmyadmin.net/
Yes there are improvements, but MyWebSQL had them implemented even before and still I would say there are *few* options ajaxified, but the overall time is still noticeably more than that of MyWebSQL.
I am glad that the team at PHPMyAdmin has gives the community some good changes, but I will still rate MyWebSQL above them. Please have a look at the demo for MyWebSQL and you will feel the change too.
[…] MyWebSQL is as robust as PHPMyAdmin with a user friendly interface and almost everything a Web 2.0 Application needs. Moreover its open source too, free to use with plenty of support for users from the development team. I will list down some of the prominent features of MyWebSQL which make it stand out, hoping that this review will help developers find a decent MySQL Web client easily. Database Read the original post on DZone… […]
Very interesting (and thanks Google for redirecting me here).
I’ve just downloaded and tested MyWebSQL on my local machine, as it gives me a better experience if I mess with data I already know. My first impression is positive.
Sleek, clean and fast, much faster than its counterpart. It’s also faster and lighter and that’s good when needs to be “installed” on the fly on a new domain. Customizable sections is also a very nice thing, I wish PhpMyaAdmin had it when I needed to teach someone its basics.
I just need to get used to it. After YEARS on PhpMyAdmin I personally find very hard to feel comfortable on a new (better) interface. It’s like moving from one platform to another one, you need some time. Let’s see if I can pass the testing period :-)
I am glad my post helped someone find a better and simpler MySQL tool.
A quick question. I tested it on my localhost and it worked fine. Now that I want to try it online, I can’t find a way to setup a default database. That’s because I can’t directly connect to the MySql host and browse all the available databases, I need to specify one. Any hint? AUTH.PHP does not show any useful info (apart from host, username, password and login type).
The ‘config/database.php’ file is for that same specific purpose you desire. Edit it and you can easily change it to list a particular db instead of seeing list.
[…] para a equipe de desenvolvimento, eles são bastante ativos na resposta às suas perguntas. Fonte: Kaizen bb_bid = "256288"; bb_lang = "pt-BR"; bb_keywords = ""; bb_name = "custom"; bb_limit = "7"; […]
Howdy. I’m very impressed with this tool but am having problems getting it to connect mysql running on Amazon EC2. Q: is there any way you could post populated auth.php and database.php files that work for you? Either I’ve got something misconfigured or there is some weird security parameter on the mysql side that is refusing connections (?)
You can go to your EC2 control panel, and find the name of the database server for mySQL. Once you have done that, open ‘servers.php’ file in the config folder, and replace the ‘localhost’ with the name of the server. Save and visit MyWebSQL page again, and use your userid and password for database. That should connect you to the db server.
(You won’t require any other change in config files other than the one mentioned here)
Thanks Samnan. Of course, about 20 min after posting this puppy I finally identified that I was missing some php/apache libraries, duh. All is well! (remember “Three Idiots”). I’m so impressed with this code, including from an esthetic perspective (rare in software)….
i have tried it in my local server it shows me junk character
Another alternative: demo.webdbadmin.com
Have you tried lightweight Adminer?
Really liked it – probably will replace the old myAdmin.
another quick editing tools http://mysurf5.netau.net
Not so far I have found new cool tool to work with mySQL – Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview