php MySQL Workbench 与 phpMyAdmin 对比
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/2663468/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL Workbench vs phpMyAdmin
提问by never_had_a_name
I've only used phpMyAdmin but then I stumbled upon MySQL Workbench that looks promising.
我只使用过 phpMyAdmin,但后来我偶然发现了看起来很有希望的 MySQL Workbench。
I wonder if someone has tried it out and could give your thoughts about it compared to phpMyAdmin.
我想知道是否有人尝试过它,并且与 phpMyAdmin 相比,是否可以给出您的想法。
Could it replace phpMyAdmin completely?
它可以完全取代 phpMyAdmin 吗?
采纳答案by K. Norbert
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.
如果您需要可视化您的表关系,Workbench 非常好,基本上这是我唯一使用它的东西,但我相信 phpmyadmin 现在也支持,通过 java 小程序?,它被称为设计器视图。
You can access it by clicking on your database in the left-hand frame, and then clicking on the Designer tab.
您可以通过单击左侧框架中的数据库,然后单击设计器选项卡来访问它。
Also, keep in mind that there are limitations on the free versions, like it cannot reverse engineer existing databases.
另外,请记住,免费版本存在限制,例如无法对现有数据库进行逆向工程。
回答by Daniel Vassallo
Could it replace phpmyadmin completely?
它可以完全取代phpmyadmin吗?
Yes it can. Actually you get much more control in Workbench, especially on the administration side. Probably the main advantage of phpMyAdminis in its web user interface, which in some cases can be more convenient than the Workbench client.
是的,它可以。实际上,您可以在Workbench 中获得更多控制权,尤其是在管理方面。phpMyAdmin的主要优势可能在于其 Web 用户界面,在某些情况下,它比 Workbench 客户端更方便。
回答by Bill Karwin
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.
我确实使用 MySQL Workbench。我认为它自早期版本以来已经走了很长一段路,它是 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.
如果不允许您的客户端 PC 直接连接到 MySQL 服务器,但允许该服务器环境中的 Web 应用程序连接,我将主要将 phpMyAdmin 用于网络托管环境。
回答by Alex Mcp
http://www.sqlbuddy.com/is pretty awesome too. Lighter-weight for just looking at your tables. Great UI too.
http://www.sqlbuddy.com/也非常棒。重量更轻,只需查看您的桌子。用户界面也很棒。
回答by Andy
DB Visualizeris my cross-platform, cross-DB tool of choice - it also has good reverse engineering and visualisation (duh!) support.
DB Visualizer是我选择的跨平台、跨数据库工具——它还具有良好的逆向工程和可视化(废话!)支持。
回答by William
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.
我开始接触 MySQL Workbench 5。到目前为止,它对于非 Web 界面客户端来说相当全面。我正在使用 phpMyAdmin 增强我们的 MySQL 环境,因为我们做网络托管。我发现 phpMyAdmin 对我们的客户来说很直观。

