10 great Alternatives to phpMyAdmin
Most people in the web development world are under the impression that phpMyAdmin is the only MySQL client out there for websites. Going a step further, some users are aware of alternative however assume that phpMyAdmin is the best.
Now, I agree that phpMyAdmin is one of the best out there and is is very user friendly. I myself also used phpMyAdmin much until recently… I got introduced to another program which within an hour became my favourite and also this led me to research others out there. Thus, this post!
10 great Alternatives to phpMyAdmin
Adminer (formerly phpMinAdmin)
A full-featured MySQL management tool written in PHP. Does more or less everything phpMyAdmin however consist of a single file only that is ready to upload to your servers and connect to the DB.
This, in my opinion, is the best MySQL client out there. It does everything you want from a very user friendly interface. However, it doesn’t come free. There is a small price tag to it but is well worth it!
One for the Mac users.
Free web based DB management tool.
Conclusion
Navicat and Adminer are probably the only other MySQL Clients you need in addition to phpMyAdmin. The rest? I’ll leave them to you to discover which is best suited to you.
Uhm … DBdesigner is like … dead …. AFAIK, even if it was a wonderful tool for DBMS creation, engenerring …
DBDesigner has become MySQL workbench.
Nice one!
‘Small’ price tage for Navicat? $179 seems to be the lowest, non-commercial license fee. Small?
Hey, Thanks for the comment. $179, I would say is small as compared to most other tools and programs you would normally pay for such as the Adobe Suite etc.
Also, Navicat is so well in functions and features that if you were developing large websites on a daily basis, you would definitely be willing to pay more after using it!
However, I do agree that, that $179 is out of the budget of many.
The price of Abode Suite is small too if we wil compare it with price of Axapta
[...] more here: 10 great Alternatives to phpMyAdmin | Web Designer Online Comments0 Leave a Reply Click here to cancel [...]
[...] 10 great Alternatives to phpMyAdmin | Web Designer Online. Unique visitors to post: 1 Tags:alternative | développement | internet | MySQL | outil | php | phpMyAdmin | Programmation | SQL [...]
Navicat is really a great tool, although $179 is a usual price tag of the very complex and advanced hard drive management and back up tools like Acronis Disk Director or Image Home. Comparing to these tools Navicat is a really small smelly fish.
Good call!!
Thanks for the comment!
Navicat is a small smelly fish in a fragranced ocean.
Hahah! Navicat is definitely different!
SQLYog is $79 / Personal Use & $99 / Commercial Use for a single license.
Doesn’t seem too bad! If it’s need then it’s a small price!!
[...] See more here: 10 great Alternatives to phpMyAdmin | Web Designer Online [...]
Ahmed,
Take a look at our free open-source alternative to phpMyAdmin –
MonoQL — http://demo.monoql.com
It’s new, but very functional… your feedback would be appreciated!
Hi Jonathan,
I’ve looked at MonoQl. Seems quite good and lots of potential for growth. Better than many out there.
I’ll keep an eye on this.
[...] 10 Great Alternatives To phpMyAdmin [...]
I have used DB Tools (PC) for the last few years, http://www.dbtools.com.br/EN/ there is a free version as well a paid version, the free one works great. I use Sequel Pro on my mac but like DB Tools much better
Great tool!! I’ll have to add this to the list! Thanks for the comment!
Well, last time I checked, HeidiSQL wasn’t working for me- it was all buggy, it’s session management was PITA and it had no “quick connect” option- so I wouldn’t recommend it to anyone who does serious development.
I have used HeidiSQL for dome time, but finally ended up with SQLyog, which is quite good and – if you work with your data a lot – much faster than phpMyAdmin.
However none of the tools I tried comes close to the tools available for Microsoft’s SQL-Server. Hey, Open Source Community? Any Volunteers?
Hahah!!
SQLYog is simply the best MySQL GUI. I’ve used everything out there and none come close to it.
Unfortunately, it is not available on a Mac. So, I live with SQLYog running in Parallels. It is really that good that I’m willing to live with Windows just to use it.
You make it sound better than Navicat! Impossible!!!
We cant forget Toad – http://www.quest.com/toad-for-mysql/
Interesting…
I think you missed these from MySQL:
MySQLWorkbench
MySQL Query Browser
MySQL Administrator
The first one is very good (derived from DBDesigner).
I’ll have to check these out! Thanks for the list.
I used HeidiSQL for a long time, and I remember it working really well.
Navicat is great, but it’s quite advanced, and the price is worth it if you’re in need of enterprise level DB tools.
MySQL’s own tools are also pretty good, and I’m not sure why they weren’t included on this list.
I have used Webyog for quite some time and it is quite good. It continues to improve steadily. The developers are also fast to respond to any discovered bugs and the user forum is very active.
I have not tried Navicat due to the price differential, BUT I note that Navicat has a report engine with it (enterprise version) which is very helpful…Better than pulling out the Crystal Report guns when a small report is required.
In fact, I wish somebody would try to publish a report engine for MySQL that is simple, succinct, functional, and affordable (e.g., in the $75-120 range).
Thanks for your list. There are a few on here I didn’t know about and want to check out!
So, I’m using Mysql GUI Tools (Query Browser, Administrator) and Mysql Workbench(5.2alpha)). Are great tools, and can be dowloaded from here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
and
http://dev.mysql.com/downloads/workbench/5.1.html
Nice! Thanks for the links!
You left out MYSQL’s Admin freebie, a bit clumsy, but gets the job done.
My apologies. Will need to add these to the list!
What happened to Toad For MySQL????
Tinymy is a great, limeweight alternative too
http://spicausis.lv/tinymy/
I use SQLYog, because it has unique feature of tunneling, among other great things. You can upload one PHP tunneling script, and work with remote server, with cloaked mysql, just like with your local mysql installation. You can also use SSH tunneling. Unfortunately free community version of SQLYog lacks this feature, however it was so useful many times it’s worth buying.
Cool!!
Hello,
I like this Tools:
DBVisualizer: http://www.minq.se/products/dbvis/
and for DB Design:
dbwrench http://www.dbwrench.com/
Greetings,
Urkman
Don’t forget MySQL query browser.
Good Call!!
Querious is a better alternative to Sequel Pro, although Querious isnt free
[...] 10 great Alternatives to phpMyAdmin | Web Designer Online phpMyAdmin alternatives – AlternativeTo.net __________________ robo47.net *überarbeitet* – Blog, Codeschnipsel und mehr Email via SMTP verschicken | Dateiuploads an Formulare schicken mit php | Mit PHP Zip-Archive erstellen und entpacken [...]
[...] Here I’m using SQL Buddy a great little alternative to phpMyAdmin just because its easier to install on centOS (for others see: 10 Great alternatives to phpMyAdmin) [...]
I have been using the community edition (free version) of SQLyog for the past 4 years and am very satisfied with it. I might be getting the pro version soon becasue I love it!
Hmm.., Ill definitely need to take a look! Thanks
The best desktop app for free is mysqlfront
http://www.mysqlfront.de
Ah, not heard of this one. Will need to give it a try!