I've only used phpMyAdmin but then I stumbled upon MySQL Workbench that looks promising.
I wonder if someone has tried it out and could give your thoughts about it compared to phpMyAdmin.
Could it replace phpMyAdmin completely?
+3
A:
Could it replace phpmyadmin completely?
Yes it can. Actually you get much more control in Workbench, especially on the administration side. Probably the main advantage of phpMyAdmin is in its web user interface, which in some cases can be more convenient than the Workbench client.
Daniel Vassallo
2010-04-18 18:50:22
does workbench miss features that phpmyadmin has?
never_had_a_name
2010-04-18 19:41:27
No, not really. Apart from the web interface.
Daniel Vassallo
2010-04-18 20:09:34
+3
A:
Workbench is very nice if you need to visualize your table relationships, basically that's the only thing I've used it for, but I believe phpmyadmin also supports that now, through a java applet?, it's called Designer view.
You can access it by clicking on your database in the left-hand frame, and then clicing on the Designer tab.
Also, keep in mind that there are limitations on the free versions, like it cannot reverse engineer existing databases.
WishCow
2010-04-18 18:52:29
If you click on your database in the left-side frame, there will be a tab called Designer, which will show the relationships between your tables. Now that I look at it completely in HTML, don't know why I assumed it's Java.
WishCow
2010-04-18 19:01:19
ok so that just visualize my table relationships. pretty good feature. but i guess you cant draw your tables and then create them? you can do that with workbench?
never_had_a_name
2010-04-18 19:27:18
+1
A:
http://www.sqlbuddy.com/ is pretty awesome too. Lighter-weight for just looking at your tables. Great UI too.
Bill X
2010-04-18 18:53:24
+1
A:
DB Visualizer is my cross-platform, cross-DB tool of choice - it also has good reverse engineering and visualisation (duh!) support.
Andy
2010-04-18 19:02:36
+1
A:
I do use MySQL Workbench. I think it has come a long way since its early versions and it's an effective substitute for phpMyAdmin.
I'd use phpMyAdmin mainly for a webhosting environment, if your client PC is not allowed to connect directly to the MySQL server, but a web app in that server environment is allowed to.
Bill Karwin
2010-04-18 19:14:41
has workbench completely replaced phpmyadmin when it comes to features? does phpmyadmin has features that you would like to have in workbench?
never_had_a_name
2010-04-18 19:23:12
Everything I need is supported by Workbench, but YMMV. I don't know if there's a one-for-one matching of features between the two products.
Bill Karwin
2010-04-18 19:40:19
A:
I'm beginning to get my hands dirty with MySQL Workbench 5. So far, it's rather comprehensive for a non-web interface client. I'm augmenting our MySQL environment with phpMyAdmin because we do web hosting. I find phpMyAdmin to be intuitive for our customers.
William
2010-08-18 14:09:18