How to change/reset root MySQL password on Mac

Published by Igor Khrupin on

Here I want to describe tutorial which works on my Mac.

MySQL version: mysql  Ver 14.14 Distrib 5.7.20, for macos10.12 (x86_64) using  EditLine wrapper
Mac OS version: Sierra 10.12.6

Please take care about root access in production environment. I’m feel free to connect to my MySQL db using root because it is my development environment.

So, to change root password which you have forgot/loose you need run couple of commands and do couple of additional steps.

1. Stop your MySQL server using System Preferences. Just open System Preferences–>MySQL and click “Stop MySQL Server” like on screenshot below: