I am not sure why this isn’t more obviously and plainly laid out somewhere. I had to run around and look for this info, so I’m putting it up here in hopes that it’s easier and more straight forward to find for others.
- Launch the MySQL Manager(/Application/MySQL Manager)
- Stop MySQL if it’s running.
- Check the “Allow Network Connections” box in the lower left corner of the window.
- Start MySQL
- Use the command line or phpMyAdmin to create a user
GRANT USAGE ON <database_name> . * TO '<username>'@'%' IDENTIFIED BY '<password>';
- To test download the MySQL Administrator tools and install.
- Launch the MySQL Administrator application.
- At the Connect to MySQL Instance window fill in the host name username and password to the MySQL server. Also add /var/mysql/mysql.sock to the Connect using socket option. It should look similar to the below image.
- If all goes well you will see an Information window with a Server is Running message
Let me know if you had to do something differently for your system.