MySQL
MySQL
8.0.16

2.0

MySQL free download for Mac

MySQL8.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.

How to Uninstall MySQL on a Mac

Learn how to uninstall MySQL on Mac and completely remove its related software components from your MacBook. Complete removal guide.

Read more

Related articles

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

How would you rate MySQL app?

27 Reviews of MySQL

Jimw
13 January 2004
Version: 5.0a

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.
(1)
2
Joseluismen
29 October 2018
Version: 8.0.12
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 :-)
(0)
jjohnsonbaddeck
24 January 2018
Version: 5.7.20
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?
(0)
Show comment (1)
Moxiesozo
04 September 2014
Version: 5.6.17
Version 5.6.20 is available: http://dev.mysql.com/downloads/file.php?id=453340
(0)
Parchment Press
03 December 2013
Version: 5.6.15
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.)
(0)
Show comments (2)
bbw7
31 December 2012
Version: 5.1.60
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/
(1)
Show comment (1)
Naoh
07 May 2011
Version: 5.1.57
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?
(0)
Show comment (1)
schmelding
01 February 2010
Version: 5.1.40
Now that Oracle has acquired MySQL what will this mean for the future of MySQL?
(0)
Show comment (1)
svoop
25 February 2008
Version: 5.0.45
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
(0)
svoop
20 February 2008
Version: 5.0.45
Download the Leo compatible PrefPane from: ftp://ftp.mysql.com/pub/mysql/download/gui-tools/MySQL.prefPane-leopardfix.zip
(0)
Show comments (2)
Mintyboy
21 October 2007
Version: 5.0.45
Anyone had any luck with LEOPARD??? I need MYSQL before I upgrade.
(0)
Show comments (2)
2
Teksestro
17 June 2007
Version: 5.0.41
Unfortunately, many developers seem to believe that MySQL is a 'free' product, when it isn't. Its licensing scheme is quite restrictive for professional production. Although newer versions are more stable, have more of the *basic, required* features that make a database engine a 'true' database system (such as foreign key support, and transaction rollback), the truth is that there are other systems out there - such as the excellent and much under-used PostreSQL - which, in my experience, have a less restrictive license, are more advanced, supporting more standard features, and still just as cross-platform.
(1)
Show comment (1)
sjk
16 June 2007
Version: 5.0.41
Anyone know why the "Mac OS X 10.4, (PowerPC, 64-bit)" downloads are still only 5.0.27?
(0)
Osxfactor
02 May 2006
Version: 5.0.20
What happened to the package installer? I installed the x86 version two weeks ago, and it had a packaged installer. I had to reinstall today (reinstalled the OS), and all of the installers on MySQL's site are command line only. I'm certain I got the Mac x86 packaged installer from MySQL's site. What happened to it?
(0)
Show comment (1)
4.5
Grantneufeld
22 April 2006
Version: 5.0.20
The MySQL package for Mac OS X makes the basic installation procedure a snap (as opposed to the old process that required building and installing it from the command line). The System Preferences pane is handy, too - although it could do with providing access to a few more options, too. You still have to do a bit of manual setup, but it's getting easier and easier. Be sure to get the free MySQL Administrator application (also from MySQL AB) for a Mac OS X graphical front end to administration of MySQL.
(0)
5
Anonymous
01 October 2005
Version: 5.0.13
No problem with opening .dmg Take care to download the right version for your OSX 10.x Easy install. I manage my databases with phpMyAdmin. For Mathematica afficionados : don't forget that Mathematica can connect (but you need to update to mysql-connector-java-3.1.10-bin.jar) to mysql databases, manages queries and handles datas. A delight.
(0)
Anonymous
01 October 2005
Version: 5.0.13
Works. Ignore these Oracle/Microsoft employees.
(0)
1
Anonymous
12 July 2005
Version: 4.1.12
Does not work. I've tried installing this about 4 times, following the instructions PRECISELY, and this thing just refuses to run. A web search reveals this happens to MANY people. If you can't make a package that'll run and install correctly, don't bother putting out a product!
(1)
Anonymous
08 June 2005
Version: 4.1.12
I cant open the DMG when it has been downloaded, anyone else with this problem?
(0)
Anonymous
28 October 2004
Version: 4.1.7
For simple tasks like phpBB forums, php forms, and other lightweight uses, this is the ticket. It's efficient, clean, and quick. It's a great little SQL for small web tasks, and getting better. If you're looking for JDBC work, or for heavier tasks such as major commercial shopping carts, go to FrontBase. They have a free dev (tell they why you want to use it is all they ask) and a free liteweight deployment license, and it's good all the way up to serious WebObjects development. (I used to recommend OpenBase, but they've gotten greedy, especially with WO dev.)
(0)
3.5
Anonymous
27 October 2004
Version: 4.1.7
Great intro to SQL databases. The feature set with MySQL is getting better and is free for personal use. For *ANY* business application they suggest you purchase a license @ $500 and are looking to enforce that policy in the future. I will use MySQL for little stuff like weblogs... but for large scale applications. PostgreSQL is the only way to go.. totally free!
(0)
Jimw
13 January 2004
Version: 5.0a
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.
(1)
Show comments (3)
Anonymous
08 December 2003
Version: 4.1.1
This version is broken. I can connect and work fine from JDBC but there is no way I can use the command-line client. Whatever query I try, I get silly errors such as "No table specified". I hope they fix it soon. Back to 4.1.0-alpha
(0)
Anonymous
07 December 2003
Version: 4.1.1
Warning: If you have upgraded and installed from jag to panther and have not changed your shell config files the instructions provided with the package will not work.
(0)
Anonymous
07 December 2003
Version: 4.1.1
It seems necessary to change ownership (chown) the data folder (usr/local/mysql/data) to the user 'mysql' in order to get past InnoDB errors.
(0)
Anonymous
07 December 2003
Version: 4.1.1
I for one couldn't get it to work on Panther server.
(0)
Anonymous
07 December 2003
Version: 4.1.1
Take Care it's NOT for 10.1!!!!! Minimum for this is 10.2
(0)
5
Anonymous
06 December 2003
Version: 4.1.1
Powerfull. Free. What more could you want?
(0)