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!
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.
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
Navicat is good, I give it that. But first: it’s not an alternative for PHPMyAdmin since it’s not a server-side tool, secondly it has really bad import processing engine, plus it’s buggy as hell.
For general database manipulations PHPMyAdmin is enough, but for deployment nothing beats usefulness of mysqldump app which is supplied with MySQL package.
I found out that importing standard SQL scripts in Navicat can take ages.
You wouldn’t settle for a second-hand tools, would you? Especially when it comes to making sure your projects are not screwed because Navicat crashed, like it does often.
[...] 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.
If you can’t download it and run it on your own server, and it is not open source, then it seems to me like someone trying to steal data. I’m not trying that!
[...] 10 Great Alternatives To phpMyAdmin [...]
[...] WebDesignerOnline 0Benzer YazılarNo Related Post Tags: MySQL, PHP, Veritabanı « [...]
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!
[...] 10 great Alternatives to phpMyAdmin [...]
Thanks for the post, I’ve been having trouble getting phpmyadmin to work with windows 7, kept loading a blank page even after following instructions for a fix, sqlbuddy seems to work great for me though.
It could be a server issue? Have you tries in Windows XP?
Nice post. I will bookmark it.
Nice and interesting article. I interested in this. Thx for it.
another wonderful tutorial, it’s easy to follow.
good post. Keep up the good work
Thanks!
Thanks for this awesome list. I am just tired of phpmyadmin (very heavy) so this is exactly what i was looking for
Great list, but you should definitely mention http://www.dbninja.com/
I use it for all my projects and think it’s amazing.
Nice one! Looks good thanks
Thanks to your list, I just tried Adminer — what a lifesaver that thing is! Surprisingly useful for a 1-page PHP file!
Definitely!!
Hello Ahmed,
You should also see MyWebSql. at http://http://mywebsql.net
Navicat is the best tool for editing mysql but Navicat is the worst when it comes to connection.
I keep checking the website for new tuts but this one has been very interesting and knowledge full . GREAT guys keep it up
Very informative, thanks for the post.
Thanks for the heads up on the Mac Sequel Pro – it’s made my programming a hell of a lot easier.
Web five.
hi,
i have this interesting classfied-advertising-website project near completion but i have never before developed and run a website. anyone with experience please advise/comment on:
1. best mysql compatible engine to deal with a large db -100k+ record with a) full-text facility & record-level locking + good security and integrity when handling 100-25 simiultaneous users – any users of maraidb?
2. i have little export/import experience of phpMyadmin – but it seems to allow import of of only very small databases. what’s the best package mentioned here that can deal with large database import and export?
3. any feature that helps to quickly and remotely export/import and save the database without much disruption to the service/site.
thanks.
A future alternative to phpmyadmin:
This is a project I work on from some time:
http://www.webdbadmin.com
Demo:
http://demo.webdbadmin.com
Take a look,
Regards.
Funny thing is HEIDI is listed last yet it is probably the best of them all. Why ?
It’s FREE…
It’s Fast
It’s easy to use
It works on windows and linux (thru wine)
It’s lightweight (even has a protable version)
It has all the features that PhpMyAdmin has and more.
It is under active development.
and did I mention it’s FREE….
Recently launched macsequel (http://www.macsequel.com) seems to be a good alternative if you are using oracle
Nice, good find