MySQL8.0.23

Name: MySQL
Rating: 2 (1 reviews)

23 January 2021

Industry-leading open-source SQL database.

Follow this app Developer website

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.23:

Performance Schema Notes

Performance Schema macros that previously expanded to dynamic calls now expand to static calls when possible to reduce processing overhead. (Bug #32028160)
Performance overhead of timer code was reduced. This should be of most benefit to workloads with high concurrency using the Performance Schema. Thanks to Georgy Kirichenko for the contribution. (Bug #31960377, Bug #101018)

Pluggable Authentication

The MySQL Enterprise Edition SASL LDAP authentication plugin now supports SCRAM-SHA-256 as an authentication method for MySQL clients and servers. SCRAM-SHA-256 is similar to SCRAM-SHA-1 but is more secure. Use of SCRAM-SHA-256 requires an OpenLDAP server built using Cyrus SASL 2.1.27 or higher.

Spatial Data Support

The new ST_HausdorffDistance() and ST_FrechetDistance() functions return the discrete Fréchet and Hausdorff distances between two geometries, reflecting how similar the geometries are.

SQL Syntax Notes

MySQL now supports invisible columns, which normally are hidden to queries, but can be accessed if explicitly referenced.

Full list of changes available here

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.

27 Reviews of MySQL

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 :-)

(1)

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 comments (2)

Moxiesozo

04 September 2014

Version: 5.6.17

Version 5.6.20 is available: http://dev.mysql.com/downloads/file.php?id=453340

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

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/

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?

Now that Oracle has acquired MySQL what will this mean for the future of MySQL?

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

Download the Leo compatible PrefPane from: ftp://ftp.mysql.com/pub/mysql/download/gui-tools/MySQL.prefPane-leopardfix.zip

Anyone had any luck with LEOPARD??? I need MYSQL before I upgrade.

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.

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?

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.

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.

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!

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

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!

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.

Show comments (3)

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

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.

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.