First let me start by saying that Navicat is amazing. The GUI is very intuitive and easy on the eyes. It also has a lot of features and options, some of which I have yet to explore. For example, connecting to a database, be it local or remote, can be done in any number of ways. You can connect straight to the database, or use an SSL, SSH, or HTTP tunnel (at the time of this writing the Linux version only supports SSL tunnels). Once connected you can do everything from create/drop/edit tables to user administration to export/import of data.
Navicat also allows you to create reports based on MySQL performance, design query's using the query design tool, schedule backups and if you are using MySQL 5+ you can also work with procedures. Viewing information contained in a database is simple as well, just double click the database, then the table. You can also convert Access, MS SQL and Excel to MySQL as well as ODBC imports.
The support for Navicat is amazing as well, with a searchable knowledge base, online and downloadable manuals, graphical tutorials and a troubleshooter. The few problems I ran into when first using the software were very quickly rectified through there site and I have been happy with the product since then.
Navicat is the number 1 MySQL GUI shareware at download.com with over 300,000 downloads. Companies that use Navicat include Sony Music, Intel, Kodak, FedEX, Ericsson, Siemens, Yahoo!, Hitachi, Lexmark, Cisco, Disney, US Department of Energy and several Universities including MIT, Univerisity of Michigan, Harvard University and Oxford University.
Outside of the MySQL command line, there are a number of options out there for database administration including PHPMyAdmin. While PHPMyAdmin is a great tool, your use of it is dependant on your server, in that not all servers have it. If you use Navicat, you are independent of the server. All you need is your login information, which you should have anyway. In short, Navicat is an awesome piece of software to add to your toolbox.