1. Dbeaver Enterprise For Mac

When it comes to databases, MySQL is a big player and widely used. Today we'll be looking at some MySQL clients we can use on Mac to view these databases.

TL;DR: My personal favorite for Mac is TablePlus. It offers a free variant which is sufficient enough.

1 TablePlus permalink

Macos Dbeaver Native Client Is Not Specified For Connection Free In that point, when I try to export a database (connected as root), I receive the message 'Client home is not specified for connection' on the top of the window, and that's what I can do, because the only option I can click is 'Close'. DBeaver for Mac (32-bit) 2.2.4 - Database management software. DBeaver for Mac (32-bit), DBeaver 1.3.2 is a database management software that supports JDBC driver. DBeaver is very intuitive and easy to use to connect to multiple databases. Medis - 💻 Medis is a beautiful, easy-to-use Mac database management application for Redis. MongoHub - Add another lightweight Mac Native MongoDB client. Postbird - PostgreSQL GUI client for macOS. Postgres.app - The easiest way to get started with PostgreSQL on the Mac. Lets you view and edit data from MariaDB, MySQL, Microsoft SQL, or PostgreSQL.

Download this app from Microsoft Store for Windows 10, Windows 8.1. See screenshots, read the latest customer reviews, and compare ratings for MarkPad.

TablePlus is the MySQL client I'm using currently. I'm still on the free plan, which only allows you to have two tabs open at a time, which is enough for me.

PROS

• Clear interface
• Quickly edit multiple rows at once
• RAW query always visible

CONS

• Only two tabs on the free version
• No click-through for linked queries

2 phpMyAdmin permalink

phpMyAdmin is another excellent resource to view your MySQL databases. It's a very good one since most servers will come with phpMyAdmin installed. Making it a good universal interface.

PROS

• Close to your server interface for MySQL
• Easy to install
• Web-based

CONS

• No syntax highlighting
• Import/Export is web-dependent, making them influenced by the server settings

3 DBeaver permalink

DBeaver is a free and open-source database tool. It's built around usability.

This tool is complete and has many cool features. For me, however, it feels a bit too much.

PROS

• Packed with useful tools
• ER diagrams!
• Linked query click-through

CONS

• A bit clunky for my taste

4 Querious permalink

Very Mac like interface and clear to understand how it works and what it does. I really like the tool however, it should have been a free tool.

PROS

• Build for Mac
• Very good interface for MySQL

CONS

• 25$

5 Sequel Pro permalink

Sequel Pro used to be my favorite MySQL client for Mac, however, they seem to have a fair amount of crashes lately. The reason I switched to TablePlus.

The tool itself is one of the best UI's for MySQL I've personally seen.

PROS

• Very clear UI
• Easy to understand and use

CONS

• Crashes often, unfortunately in the latest releases

Thank you for reading, and let's connect! permalink

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter

About the App

• App name: DBeaver Community Edition
• App description: dbeaver-community (App: dbeaver/dbeaver.app)
• App website: http://dbeaver.jkiss.org/

Install the App

1. Press Command+Space and type Terminal and press enter/return key.
2. Run in Terminal app:
   ruby -e '$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)' < /dev/null 2> /dev/null ; brew install caskroom/cask/brew-cask 2> /dev/null
   and press enter/return key.
   If the screen prompts you to enter a password, please enter your Mac's user password to continue. When you type the password, it won't be displayed on screen, but the system would accept it. So just type your password and press ENTER/RETURN key. Then wait for the command to finish.
3. Run:
   brew cask install dbeaver-community

Done! You can now use DBeaver Community Edition.

Dbeaver Enterprise For Mac