Blog

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

  1. Install MySQL Community Server.
  2. Install MySQL Workbench.
  3. Open a command line (like Terminal) and run the commands below: 
    mysql -u root -p
GRANT 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;
  4. Restart MySQL on Mac.
  5. Restart MySQL Workbench and open a connection.

Leave a Reply