shutdown taking too long after sierra upgrade - about 20 minutes

AAAH!! Finally! You're my hero! I've been struggling with this problem for months now (those months seemed like years, actually). At some point I was too afraid to shutdown or reboot my MacBook because it got me too annoyed. I just couldn't handle the pain anymore. I almost accepted the fact that this problem was never going to be solved and that I should have lived with it until the end of time (yes, that's how pessimistic I got). Today I plannend my final fixing session. If it wouldn't succeed I just had to accept this terrible problem and live in agony, I told myself.

I poured myself a good cup of coffee, put on some music to relieve a bit of stress and started debugging, again. Not much hope was left in me, but after a while I found this topic. Because I had tried a ton of 'solutions' I wasn't very optimistic at first, but when I clicked 'Restart...' after upgrading to MySQL 5.7.17 (from 5.7.13) I felt the adrenaline (or the third cup of coffee) all over my body. The screen faded to black instantly, as usual. Normally the waiting then starts, but now, my friends, my MacBook finally rebooted, and quickly! In the blink of an eye!

The feeling of relief I'm experiencing now is hard to describe, I think this is already the best day of this year. I still can't believe this just happened. Again, thanks so much!

Thanks very much for the inputs. Exactly my feelings. I had been suffering this problem for the last 4 to 5 months since upgrading to Sierra and could not figure out. All the usual Mac tricks of resetting PRAM etc did not work. Yesterday I came upon this support thread and updated my MBA -- the first shutdown was still slow and delayed, after the upgrade with the file mysql-5.7.18macOs10.12-x86_64.dmg -- and kept me wondering till I realised that the previous version was sitting in the RAM. Oh! boy --- was the second shutdown fast !!-- and proved to be a great day !! Today I repeated the same thing for my MacMini and got exactly the same results. Thanks guys.

I may have the same problem but I don't know how much it will take because I force it to shutdown after waiting for 5 or 10 minutes.

And I also have this issue when I try to reboot.

Thanks. I turn down mysqld in activity monitor then fixed.

Thank you for sharing the "responsible" of the problem!

My computer wasn't shutting down and I thought it was a problem of another kind with mac OS Sierra. I was even planning a downgrade to El Capitan because it wasn't shutting down no matter if I wait until the next morning.

I'm going to try to search a fix for the problem, at least temporal, until Oracle releases a new version compatible with Sierra.

If I'm able to find one, I'll post it here.

Thank you again!

I solved the problem installing a new version of MySQL (5.7.15).

Maybe during the upgrade to Sierra, some permissions were affected. I didn't check for that but I also tested reinstalling the same version I had before (5.7.14) and the problem was gone.

thank's! it helped a lot!

Keep the <alt> button pressed while shutting down; system will shutdown within 12 secs. I had the same issue and believe me my 7 years old son discovered the solution.😉

That helped, Thank you

This was also the problem on my system.

Keep the <alt> button pressed while shutting the computer down. It will not take more than 12 sec>>>

Thanks! this solved my problem...

Thanks, this solved it for me