Add password to root MySQL on Mac (brew)

ERROR! The server quit without updating PID file
Table 'mysql.role_edges' doesn't exist
Access denied for user 'root'@'localhost' (using password: NO)
  • A: Try mysql_secure_installation and follow instruction to setup new password.
    Credit to StackOverflow.