Navicat for MySQL
Your rating: Now say why...

0

Graphically manage MySQL databases.   Shareware ($79.00)
Add to my Watch List
Email me when discounted
Navicat for MySQL Client from PremiumSoft, is an integrated GUI tool let you perform MySQL administration and database development in an easier way. Advanced features allow you to create data models, import/export data, backup, transfer databases, create queries, and manage your local or remote MySQL server. It also includes a full-featured graphical manager for setting the users and access privileges and more.

Navicat is sophisticated enough for professional developers, yet easy to learn for new users. It is also available for Windows and Linux and translated into 7
What's New
Version 11.0.16:

Improvements:

  • Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.
Bug Fixes:
  • Tab was unable to be dragged and reordered in full screen mode.
  • Crashed when using Find function in Table Viewer.
  • Copy and Paste did not work on tables with auto-incremented columns while saving a record by clicking "tick" icon in the Table Viewer.
  • Crashed after changed the "Use advanced connections" and press "ok" button in Table Viewer.
  • Parameter list not able to show while including CHARACTER type in function parameters in Function Designer.
  • Crashed when selecting a suggested word that required quoting in Scintilla auto completion.
  • Crashed while scrolling table in Query Builder and exited Navicat.
  • int with "." as Thousand Separator did not import correctly in Import Wizard.
  • The datetime format showed in the export profile did not match the format used in the original table.
  • Date and time were exported incorrectly while using a EDT time zone.
  • Message Log was unable to save correctly for the Preview function in Data Synchronization.
  • Table dataset and collation info on CREATE TABLE queries not able to synchronize in Structure Synchronization.
  • When changing a relation's referencing schema, the relation remained in the table but the relation line in diagram was removed under Table Designer in Data Modeling Tool.
  • Crashed when double-clicking the connection tree under Synchronize to Database in Data Modeling Tool.
  • Schedele helper did not work although jobs still run in old version.
  • Website version: Typed in the export queries filepath directly would cause file creation error in Data Synchronization.
  • App Store Essentials version: Crashed when purchasing Code Completion feature without SQL Builder in View Designer.

Version 11.0.16:

Improvements:

  • Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.
Bug Fixes:
  • Tab was unable to be dragged and reordered in full screen mode.
  • Crashed when using Find function in Table Viewer.
  • Copy and Paste did not work on tables more...
Requirements
Intel, OS X 10.6 or later



MacUpdate - Navicat for MySQL



Navicat for MySQL User Discussion (Write a Review)
ver. 11.x:
Your rating: Now say why...
Overall:
(22)

sort: smiles | time
burypromote

+1
MarkRobinson1897 commented on 07 Apr 2013
You can check one more tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.
[Version 10.1.3]


burypromote
-1

+7

Cfoster reviewed on 29 Nov 2012
A while back I wrote a review for v9 that mentioned it was buggy, so I thought I should follow-up to say that I have found v10 to be rock solid. HUGE improvement in reliability in this release.

Since I didn't mention it before I should point out one of Navicat's features that if you use it once will make the app worth the price: If you open a connection to two databases at the same time, you can migrate your tables (and views, procedures, etc) just by drag & dropping them from one db to the other. Boom. Done. No exporting & import. It's barely more difficult that moving a file across a network. Amazing.

The other parts of the app continue to be refined, making editing tables, and stored procedures just a *little* bit nicer.

And I know it's been there for a while, but the SSH tunnelling feature is enormously handy when trying to access a database behind a firewall.

Thanks Navicat devs!
[Version 10.1.1]


burypromote
+1

+7

Cfoster reviewed on 08 Jan 2011
There are a number of decent and *free* database management programs out there but I found Navicat to be well worth the money. (You might think it seems like a lot but if you're spending even a few hours/week managing a DB I think Navicat is good value.)

Unfortunately I'm stuck on version 8 because while the interface on 9 is much nicer, I find it crashes pretty much every time I use it. Sometimes it's because of a timeout on the server, sometimes it's just seems random.

There seem to be a few buggy interface elements that pop up from time to time as well (the enum default-value menu comes to mind -- it often chooses the values of the previously selected enum field).

So I'll stick with 8 for now. Hopefully 9.2 brings some stability.
[Version 9.1.3]


burypromote
+1

+95

Macd reviewed on 14 Dec 2010
Crazy stuff! I've been using Navicat for a long time now, and it proven itself an indispensable tool for managing MySQL databases. And I have lots and lots of them.
Navicat does absolutely everything I need. Transfers, queries, data/structure sync, SSH/HTTP tunneling..
And support is beyond incredible! I files a crashing bug to them and got it fixed, AND the updated version of the program released in under 48hrs. I'm shocked!

It is indeed an expensive tool, but considering how much time it'll save you in a long run, and hourly rate of almost any DBA/programmer who do DBs for living, the price is rather easily justifiable.
Highly recommended.
[Version 9.1.2]


burypromote
+1

+48

Drtyrell969 reviewed on 23 Aug 2010
This is THE product to own if you're doing MySQL work. No more myPHPAdmin crap. The power to not only create the database, but to managed it with micro edits right in the GUI is unmatched. Heavily recommend for those of you who know that time does equal money. ;-)
[Version 9.0.9]


burypromote
+1

+15
Jamesehale commented on 29 May 2010
What's new refers to Navicat PREMIUM, not Navicat MySQL.
From Navicat's site:

May 20 2010
Navicat for MySQL (Mac) version 9.0.5 is now available
Improvements:
If the row is selected, Filter Wizard will now display the words in white color.
Query Builder supports to show diagram for some incomplete statement.
Bug Fixes:
Crashed when getting server Information on Information View if connection failed.
Improper join lines were displayed when joining multiple tables in Query Builder.
Crashed when parsing some improper SQL statements.
Wrong bit field default values were displayed in Table Designer for MySQL version 5.1.31 or above.
[Version 9.0.5]


burypromote

Banshee_z71 reviewed on 13 May 2010
Version 9 is the update for Navicat I have been waiting for. I've used Navicat for 6+ years on both Windose and Mac. It has always had the same problem on both OS. Would randomly crash. At least 1 or 2 times a day. But with Version 9 on my Mac I have never had a crash. Definitely worth the $50 upgrade just to get rid of the random crashes. Buy it!
[Version 9.0.4]


burypromote

+30
detlevski commented on 17 Feb 2009
Still no Access import like the Windows version, very disappointing to see Macusers still have to put up with a crippled version.
On the developers site it is almost impossible to find out what's new and why I would have to upgrade for $50,-.

It's a pity, because Navicat may have some quirks, but I work with Navicat all day and overall I am very pleased.
[Version 8.0.1]


burypromote

macaron1 reviewed on 11 Aug 2008
Have been using Navicat for over two years. As far as I'm concerned, it's the best MySQL editor on the Mac.

If you do heavy editing, you'll appreciate its versatility compared to web-based solutions. Download and check out the 30-day trial. Or grab the free version off their website if you are going to use it non-commercially.

Some minor quibs:

SSH tunneling is buggy. It regularly crashes whenever I use SSH tunneling on the road.

Related to the above: You lose all your unsaved queries when it crashes. Very frustrating if you have several or more query tabs open!

The GUI for editing triggers and stored procedures is non-intuitive. I frequently find myself typing up the SQL in a text editor like TextMate and pasting it into Navicat.

When in table design, you can't duplicate rows. Also, there is something unintuitive about the whole process because I find myself having to resort to the mouse when adding stuff: Tabbing will not get you to all editable fields.

The Mac version, for some reason, trails one point behind the Windows/Linux version. Not sure what you lose, but probably implies they devote less resources to the Mac side of their business.

The query tool does process multiple SQL commands but will return results for only the last. Also, older results will disappear as soon as you edit the SQL or want to type in something new. So, whenever I need to compare results of two or more queries, I find myself opening multiple tabs and going back and forth between them. Would be nice if I could see the results on the same window somehow.
[Version 7.1.4]


burypromote
+1

+77

cenocre reviewed on 07 Jan 2008
If you think that being forced to install things via command lines in Terminal is primitive and idiotic and should have been abandoned in 80's, then you'll like Navicat. It is light years better and easier than using WebMin.

The interface still needs works, to improve the flow and ergonomics (HI considerations seem to have been forgotten about by most including Apple about a decade ago.), but this is a very useful and rather featured tool.

And, so what if you have to pay. Good work deserves compensation. Besides if you use this for business you will have done dozens of things with this before you have even figured out how to install , access, and use WebMin. Additionally, using an application for direct access always blows away any browser access in almost every way shape and form, especially speed, convenience and features.

Use your brain, use open source, if it is good, but too much open source stuff will waste years of a professional's life. If you want to get work done, rather than blindly hold on to open source, command line installs, and browser just because it is free, by all means, get Navicat.
[Version 7.0.11]


burypromote

-1
intelios had trouble on 23 Feb 2009
Could someone point me to to right direction on where to find the menu for opening a new Main window. I sometimes accidentally close the main window and cannot bring it up without restarting the entire application. Any help would be appreciated.

Thanks.
[Version 8.0.2]

3 Replies

burypromote

+30
detlevski replied on 27 Apr 2009
You are right, you just have to quit the program to get the window back, it's a bit stupid.
Why don't you report it, I am sure they will fix it.
Probably they are PC people and used to such UI glitches.
burypromote
John Kei replied on 28 Apr 2009
You can just click on the Navicat icon on the dock and the main window will be shown again.
burypromote

-1
intelios replied on 28 Apr 2009
@JOHN KE.

Thank you. This works beautifully. I still think they should just incorporate a shortcut or into the Window menu. For now, this will do.

=D

Macgui rated on 07 Feb 2013

[Version 10.1.3]



-2

Khmz rated on 25 Nov 2011

[Version 10.0.4]



-2

Khmz rated on 06 Sep 2011

[Version 10.0.0]



Mrbyte rated on 05 Aug 2011

[Version 9.1.7]



+4

Captainpovey rated on 27 May 2011

[Version 9.1.6]



+4

Mammut rated on 13 Feb 2011

[Version 9.1.4]


Downloads:48,771
Version Downloads:206
Type:Internet : Servers
License:Shareware
Date:11 Mar 2014
Platform:Intel 64 / Intel 32 / OS X
Price: $79.00
Overall (Version 11.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-10 of 28
1 2 3 >
Displaying 1-1 of 1
Displaying 1-6 of 6
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
Navicat for MySQL Client from PremiumSoft, is an integrated GUI tool let you perform MySQL administration and database development in an easier way. Advanced features allow you to create data models, import/export data, backup, transfer databases, create queries, and manage your local or remote MySQL server. It also includes a full-featured graphical manager for setting the users and access privileges and more.

Navicat is sophisticated enough for professional developers, yet easy to learn for new users. It is also available for Windows and Linux and translated into 7 major languages.


- -