php – MySQL Workbench vs phpMyAdmin

php – MySQL Workbench vs phpMyAdmin

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.

Workbench is very nice if you need to visualize your table relationships, basically thats the only thing Ive used it for, but I believe phpmyadmin also supports that now, through a java applet?, its called Designer view.

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.

php – MySQL Workbench vs phpMyAdmin

I do use MySQL Workbench. I think it has come a long way since its early versions and its an effective substitute for phpMyAdmin.

Id 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.