Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing Sequel Pro vs PHPMyAdmin, the Slant community recommends PHPMyAdmin for most people. In the question“What are the best MySQL management tools?” PHPMyAdmin is ranked 2nd while Sequel Pro is ranked 3rd. The most important reason people chose PHPMyAdmin is:
Editions can be performed over a result table just by clicking the desired field.
Question Ranking
Pros
Pro Great UI
Clean, easy to use, highly polished interface.
Pro Native OS X from the start
Unlike other solutions, Sequel Pro was built specifically for OS X and for MySQL from the beginning and as such the design takes better advantage of OS X features and is optimized for MySQL.
Pro Free and open source
Licensed under MIT.
Pro Multiple connection methods
Sequel Pro can choose between standard and SSH connection methods.
Pro Multiple import/export options
Sequel Pro can export to SQL, CSV and XML files and import SQL and CSV files.
Pro Command line access
Sequel Pro can also access and manage everything from the command line.
Pro Excellent user management
Has easy user privilege management.
Pro Highly flexible filters
Sequel Pro has highly flexible and customizable filters.
Pro Easy to edit
Editions can be performed over a result table just by clicking the desired field.
Pro Available in most hosting services
Because of its portability, popularity and robustness phpMyAdmin is included in most hosting services that support the LAMP stack.
Pro Easy installation
The installation process itself is very simple, you need to have PHP and MySQL installed on your server, extract the files to a specified directory and run the install script. If you get stuck somewhere there's a lot of help online. The official wiki is very good too as far as the installation goes.
Pro Complete functionality
phpMyAdmin is complete as far as features and functionality go. You can even build a full website without knowing any MySQL.
Pro Portable
phpMyAdmin can run in a web browser, this makes it a very portable tool because it can be run on any computer and on any OS as long as it has a web browser installed.
Cons
Con Crashes constantly
Crashes when working with mysql 8.0.12 for macos 10.13. Unable to do anything.
Con Not maintained
The app crashes when you close a tab.
Con No MySQL 8 support
Con Not adapted for MacOS Catalina
Con No multiple query tabs
Sequel Pro does not support multiple query tabs in its editor. This is incredibly frustrating for a power user.
Con Text in the query lost on connection failure & crashes
Con OS X only, no Linux or Windows versions
Power users have to manage in many different environments. A consistent admin interface is hugely beneficial.
Con Query editing capabilities much poorer than MySql Workbench, Querious, and others
Con No visual query editor
Con Unable to import from binary SQL files
I frequently import binary multipolygon data from another source, and it won’t open.
Con Confusing interface
It may take some time to get used to it.
Con No schema visualization
Con No code higlighting
phpMyAdmin does not have any code highlighting or auto-completion capabilities, unlike other options.
