Best Mysql Gui Tool For Mac
I've been running into a lot of shortcomings with phpMyAdmin, especially when it comes to anything Foreign Key related. Imports and Exports can be shady, and working with large amounts of data is a chore.
MySQL GUI Tools 5.0r12 - Administration tools for MySQL. Download the latest versions of the best Mac apps at safe and trusted MacUpdate. Download, install, or update MySQL GUI Tools for Mac from MacUpdate. Administration tools for MySQL. OldVersion.com Points System. When you upload software to oldversion.com you get rewarded by points. For every field that is filled out correctly, points will be rewarded, some fields are optional but the more you provide the more you will get rewarded! While MySQL database tools and utilities abound for Mac users (as well as many other database apps—check this list from Pure Mac), the reality is that there are not many usable MySQL database apps for the average Mac user, at least in the same vein as Mac apps. There are some, and many are very powerful.
I love that it runs in a web browser so that I'm able to run it on any host, but I've been moving from shared environments to dedicated hardware and have the ability to access MySQL remotely now.
Can anyone recommend the next level of MySQL administration once a developer has graduated from PMA? Is there an amazing GUI tool, or should I finally memorize those CREATE TABLE statements and use the command line?
I've been a PMA user since 2004.
closed as not constructive by slhckApr 17 '13 at 14:52
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
4 Answers
I've been pretty happy with Sequel Pro. Free, expandable.
Doug HarrisDoug Harris
How about Navicat? Works on Mac and Windows. And on multiple types of databases (different products though). There is a free version in the app store to try
Canadian LukeCanadian LukeHave you tried the MySQL Workbench? It's directly from MySQL themselves and quite good. The catch is you need to be able to directly connect to the database, so you might have to use an ssh forward if the database is locked down to local-only connections for security reasons (Whereas phpMyAdmin is accessible to anyone that the webserver permits).
It has GUI builders for creates, updates, alter tables, etc., and dare I say, makes working with MySQL tables almost as easy as using MS Excel, save for you having to click commit to save your changes.
Darth AndroidDarth AndroidI've used EMS SQL Manager several years ago. It is part of their SQL Studio, which has even more features. Both are rather expensive, Windows-only tools:
SQL Manager for MySQL allows you to create/edit all MySQL database objects, design MySQL databases visually, run SQL scripts, import and export MySQL database data, manage MySQL users and their privileges and has many other useful features for efficient MySQL administration.
Update: They apparently have a free 'lite' version, available for download, I cannot find what's the difference from the full version is.
haimghaimgNot the answer you're looking for? Browse other questions tagged macosmysqlphpmyadmin or ask your own question.
What is the best GUI for managing MySQL 5.1 installation? Would like something as close to SQL Server's management tools as possible as that's where my experience is. The management client would need to run under Windows (XP, Vista (32 and 64-bit flavors), and 7 (32 and 64-bit flavors).
Scott MayfieldScott Mayfieldclosed as not constructive by BoltClock♦May 22 '12 at 10:09
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
5 Answers
I have been using SqlYog for about several years now and am very happy with it. It has the best interface I have seen. Navicat is good, but SqlYog is better. Plus there are several 'power' features that come in handy like the query builder tab.
The Pro version is about $70 but there is a free community version.
If you also have a PHP/Apache server, you can user phpMyAdmin or SQL Buddy. Otherwise, the MySQL GUI Tools (Query Browser and Administrator) are good.
Modern web browsers have the developer tools you can use to ensure your website works well with all web browsers without the need to download extra web browsers. If you are on a Mac, the default web browser Safari also has the developer tools. Safari for Developers. Safari is the best way to see the sites on iPhone, iPad, and Mac. Thanks to blazing-fast performance and industry-leading energy efficiency, hundreds of millions of users enjoy exploring the web with Safari. The Safari Developer Tools for the macOS browser can be enabled and displayed in Safari > Preferences > Advanced > “Show Develop menu in menu bar” for Safari version 12 and earlier. Then from the Safari “Develop” menu select “Show Web Inspector” or use the keyboard shortcut Option+Command+i When opened the Safari developer tools pops open in a new window, to get it. Use the developer tools in the Develop menu in Safari on Mac. If you’re a web developer, the Safari Develop menu provides tools you can use to make sure your website works well with all standards-based web browsers. Safari tools menu. Web Development Tools. Apple has brought its expertise in macOS and iOS development tools to the web. Safari includes Web Inspector, a powerful tool that makes it easy to modify, debug, and optimize a website for peak performance and compatibility on both platforms.
John PaulettJohn PaulettCheck out MySQL Administrator and other GUI tools here.
Brian EnsinkBrian EnsinkYou might want to have a look at HeidiSQL. It's free and fast.
Mysql Windows Gui
marekventurFree Mysql Gui Tool
marekventurBest Mysql Gui Tools For Mac Os
So far the closest thing I've found is Navicat Lite http://www.navicat.com/