Does macOS sierra support any version of mysql?

MySQL 5.6.31 just works for me. I haven't tested it extensively though since I'm more interested in why MySQL 5.7 *doesn't* work.

With MySQL 5.7.13, mysqld hangs on exit. The installation does not finish because when mysqld is invoked to create the data directory, it never exits. It seems as though the installation *is* complete at this point, but because the installer fails, the root password has to be recovered as documented in the MySQL reference manual, or the data directory has to be removed and re-created manually, which will allow the user to see the generated password.

The hang on shutdown is probably the same issue. The default installation includes the launchd script you found that is responsible for starting mysqld at boot. Removing it fixes your problem, but it's also possible to simply turn autostart off in the MySQL preference pane that's part of the installation.

The mysqld-debug executable does not seem to hang, so if MySQl 5.7 is required for testing purposes it might be possible to replace /usr/local/mysql/mysqld with mysqld-debug in the same location as a temporary workaround.

Hello!

I had the same problem and fixed It upgrading my current installed version (5.7.10) to version 5.7.15.

I used this guide for upgrading without losing database information:

https://coolestguidesontheplanet.com/upgrade-mysql-database-5-5-5-6-osx-10-8-mountan-lion/

🙂

HUGE! Thank you 🙂

I am extremely frustrated with this MySql issue. Never have I had so many problems. All seems to be with this MacOs Sierra. I have tried using MAMP and MySql works fine BUT only locally. I can not access it remotely at all, no matter what I do. I have tried installing MySql natively and the System settings says the server is running, but there is no access to it, no command line no nothing. This is so bad that I will be forced to build a linux server just to continue development. I have been developing for years. The differnce is that I bought a new iMac that came with Sierra. So my original Dev machine is gone. Perfect. Why would MAC all of a sudden stop support for MySql? Unless it is a fight between Mac and Oracle?

Hello Xilobyte,

There is no fight that I am aware of. Apple and Oracle are in different markets and are not competitors in any aspect. As far as I know, they are each big customers of the other.

I don't know if macOS is really the right platform for this kind of activity anymore. If you really, really want to run a service locally like this, I recommend Docker instead. Then you can run MySQL under Linux right on your Mac. Docker is more friendly to local CPU and disk resources than a VM.

Taking it a bit further, you might want to consider cloud services. They have definitely reached commodity level now. Prices for services on the research and development scale are very reasonable, if not flat-out free. The cloud providers plan to make money when you deploy. Unless you plan on doing development on a week-long train trip without internet, there is little reason to have local services anymore.