Fixing MySQL Workbench Issues on macOS Mojave
Posted on August 5, 2019 in MySQL by Matt Jennings
If you are having problems opening a new connection in MySQL Workbench in macOS Mojave, follow the commands below (per these PhpStorm instructions from JetBrains):
- Install MySQL Community Server.
- Install MySQL Workbench.
- Open a command line (like Terminal) and run the commands below:
Shell12345mysql -u root -pGRANT ALL PRIVILEGES ON . TO 'root'@'localhost' WITH GRANT OPTION;CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;FLUSH PRIVILEGES;
- Restart MySQL on Mac.
- Restart MySQL Workbench and open a connection.