MySQL
MySQL
8.0.16

2.0

MySQL free download for Mac

MySQL

8.0.16
11 July 2019

Industry-leading open-source SQL database.

Overview

MySQL, the industry-leading open-source SQL database, is an accessible, easy-to-use relational database management system (RDBMS). As an alternative to Oracle and SQL server, MySQL offers features and capabilities that were once only available to users of expensive proprietary systems.

What's new in MySQL

Version 8.0.16:

Notes: For a full list of changes go here. Upgrade from MySQL 5.7 to MySQL 8.0 is only supported using the in-place upgrade method. Downgrade from MySQL 8.0 to MySQL 5.7 (or from a MySQL 8.0 release to a previous MySQL 8.0 release) is not supported. The only supported alternative is to restore a backup taken before upgrading.

Bugs Fixed:
  • NDB Cluster: EXPLAIN of a query executed with table access type eq_ref could also show a condition being pushed down, even when condition pushdown was not supported for the query. Now the access type is checked before NDB checks the condition for a possible pushdown optimization.
  • This fix does not affect handling of tables which are part of a pushed join, for which NDB continues to support pushed conditions as before.
  • InnoDB: Undo tablespaces remained unencrypted after enabling undo tablespace encryption at startup.
  • InnoDB: Problematic macros introduced with undo tablespace DDL support in MySQL 8.0.14 were revised.
  • InnoDB: Static thread local variables defined at the wrong scope were not released at thread exit.
  • InnoDB: The performance_schema.data_locks LOCK_DATA column only showed the secondary index values of the locked record for a lock placed on a unique secondary index, which was not sufficient to ensure the uniqueness of identified records. The clustered index column values of the locked record are now appended.
  • InnoDB: An incorrect count of transactions using a rollback segment for recovery of an XA transaction prevented an undo tablespace truncation operation from proceeding and left the purge thread busy checking for the undo tablespace to become empty.
  • InnoDB: Invalid assertions were raised at startup after a failure to retrieve the space ID of a compressed file-per-table tablespace. The invalid assertion code was removed.
  • InnoDB: Optimized InnoDB internal temporary tables did not support in-place UPDATE operations, which caused the number of delete-marked records to increase continuously. The large number of delete-marked records could cause longer than expected query execution times.
  • InnoDB: The std::sort function in the Variance-Aware Transaction Scheduling (VATS) algorithm was replaced by the std::stable_sort function to preserve the original FIFO order for transactions of equal weight.
  • InnoDB: Write-ahead did not work as expected due to an incorrectly initialized variable.

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

27 MySQL Reviews

See all

Rate this app:

Jimw
13 January 2004

Most helpful

To begin with, let me state that I have not either downloaded or used this product. However I have been acquainted with similar products and have browsed the web site. SQL databases are not for novices. Generally, if you are looking for something for your music, video collection, wine list, or exercise routine, this is not what you want to use. While it is "free" the company makes its money off of support, consulting, training, and certification. It is designed to be run off of servers and support many users for powerful relational databases. It was not designed with the casual or home user in mind, except as a user logging into a running database over a network. On the other hand, this might be a place to start if you want to learn about becoming a database engineer or designer. While I am always looking for a good deal or something free, this may not be it for the average user when it comes to databases. Frankly I can't think of a free simple, easy to use general purpose database offhand. For a quick solution with limited records, I use AppleWorks - yes it is still available, works in Panther, has a real flat file database, and is relatively inexpensive. Otherwise I use FileMaker. While I believe it is somewhat overpriced for an individual user, it is stable, fairly easy to use and does the job well. FileMaker now has relational database capabilities and can be easily be published on the web. If you don't know what a relational database is, you probably don't need one and can get by with a traditional flat file database. Trust me, they are easier to setup, deal with, understand and maintain. Please note: Excel is NOT a database, it is a spreadsheet, although it can be made to look like a database. No spreadsheet I know of is a true database. On the other hand, databases can be made to look like spreadsheets as well.
Like (1)
Version 5.0a
Joseluismen
29 October 2018
New version 8.0.13. This version requires system 10.13 or 10.14. The intermediate versions of the version, required 10.12. The previous versions of 8 (8.0.0 dmr)accepted 10.11 but I think they withdrew the support before the initial final version. Browsing your website, I only see the final version (not beta or prior) compatible with 10.11 version 5.7.16. In MU, they offer 5.7.17 as compatible, but the MySQL site mentions only 10.12. Are versions of 10.12 compatible with 10.11? Can I then use version 5.7.20? Why do not they already offer support for 10.11 with security updates for some previous version? It was not my favorite, because it needs a lot of previous study to use. But the price of FileMaker, and its obsolescence made me consider this option. I see that there is no other solution to pay, and stay updated forever. With new computer as the Apple gurus send, every 9 months :-)
Like
Version 8.0.12
jjohnsonbaddeck
24 January 2018
I have a small library card catalogue archive for which I'm going to build a database. Each card might have 3 separate entries on it...probably a total of around 14,000 cards. Will MySQL work for me?
Like
Version 5.7.20
1 answer(s)
Oestmann
Oestmann
17 May 2018
yes
Like
Moxiesozo
04 September 2014
Version 5.6.20 is available: http://dev.mysql.com/downloads/file.php?id=453340
Like
Version 5.6.17
Parchment Press
03 December 2013
Why o why does MacUpdate track Unix software in the main Mac software channel? Just a suggestion, but i would prefer it if you had a separate tab/category for server software, daemons, CLI utilities and the like. That way, the 90% who don't use it won't have to contend with the added entries on the tracker. (I do personally use a lot of server-oriented software and CLI tools, so i would personally check that category for updates. But my preference would be to separate them out to another category listing.)
Like
Version 5.6.15
2 answer(s)
SickTeddyBear
SickTeddyBear
05 December 2013
"Why o why does MacUpdate track Unix software in the main Mac software channel?" Because OS X is UNIX, a POSIX certified BSD descendant to be exact. There is a significant percentage of the Mac user community who use them specifically because of their workstation roots. We don't make a distinction between the different layers, as it's all part of what makes OS X wonderful.
Like (2)
Derekcurrie
Derekcurrie
12 September 2014
... Also, MySQL has Mac GUI components, making it a directly usable Mac database system.

I personally would enjoy having all the Mac usable X11 and MacPorts projects included in the Mac software channel as well. The Mac universe is far more vast than simply Mac GUI compiled applications. It takes some learning curve time to get to know this extra-dimensional universe, but it's quite large and fun.
Like
bbw7
31 December 2012
The MU download only provides some 0.5kb (!) tar.gz file, and the developer link only leads to some fairly small-sized search engine code. However, the below link seems to provide the full-on file in several formats for OS 10.6: http://dev.mysql.com/downloads/mysql/
Like (1)
Version 5.1.60
1 answer(s)
MacUpdate-Ryan
MacUpdate-Ryan
31 December 2012
Thanks for the heads up bbw7. I've updated the listing and fixed our download links.
Like (1)
Naoh
07 May 2011
This is odd. The MySQL download page lists 5.5.12 as the lastest version, and 5.1.57 as an older version. Yet MacUpdate is linking to 5.1.57. What gives?
Like
Version 5.1.57
1 answer(s)
SickTeddyBear
SickTeddyBear
07 May 2011
Server software has different version numbering from regular software. With servers, stability and continuity are often more important than features, therefore, server software has multiple parallel branches that are maintained side-by-side, and one only upgrades to a higher numbered version when absolutely necessary. So, with MySQL, 5.5.x is the latest feature updated branch, but 5.1.x is not "old", it's merely a separate branch, which, having been in use for a longer period of time, is probably slightly more stable. In any event, MU should include links to the latest version of 5.1.x and 5.5.x. Both are valid and current branches of MySQL. With server software, it's not about either/or but both/and.
Like
schmelding
01 February 2010
Now that Oracle has acquired MySQL what will this mean for the future of MySQL?
Like
Version 5.1.40
1 answer(s)
Mikaelf
Mikaelf
16 September 2011
More development resources. MySQL is now way faster....
Like
svoop
25 February 2008
Version 5.0.51 has just been released, however, it doesn't work out of the box on my Mac with OS X 10.5.2. I've filed a bug report that contains a workaround that circumvents the permissions issues. However, this is okay for a development Mac like min, you MUST NOT do it on a production system. http://bugs.mysql.com/34814
Like
Version 5.0.45
svoop
20 February 2008
Download the Leo compatible PrefPane from: ftp://ftp.mysql.com/pub/mysql/download/gui-tools/MySQL.prefPane-leopardfix.zip
Like
Version 5.0.45
2 answer(s)
Stormchild
Stormchild
27 February 2008
Thanks, it works! I recently found a "fix" to get the preference pane working in Leopard, but it didn't work for me. This "official" fix works great though.
Like
Version 5.0.51a
Mintyboy
Mintyboy
02 May 2008
thanks so much for this link. I stumbled on this form about a year after my original post-- and have been booting via command line for too long. For those of you who need more info... this pref. pane works for those who did the custom work-around in the previous posts on this topic. Worth trying at any rate... you can't harm your computer.
Like
Version 5.0.51b
Mintyboy
21 October 2007
Anyone had any luck with LEOPARD??? I need MYSQL before I upgrade.
Like
Version 5.0.45
2 answer(s)
Vincentj
Vincentj
28 October 2007
Yes. MySQL 5.0.45 is working with Leopard. But you have to setup a path with the commands : sudo mkdir /var/mysql/ sudo ln-s /tmp/mysql.sock /var/mysql/mysql.sock Note that MySQL PreferencePane is not working correctly. PHP 5.2.4 is already installed in leopard (but not activated).
Like
Version 5.0.45
svoop
svoop
28 October 2007
It's a permissions issue. This will solve it "brute force", I'm too lazy to figure out exactly which permissions misbehave for my development only system. sudo chmod -R a=rwX mysql-5* Here's more: http://bugs.mysql.com/bug.php?id=28854
Like
Version 5.0.45