Please note: many of these tricks are done from the perspective of a mac user.

Locating the my.cnf file

Please note: the default location where mysql config files are stored for mac users under

/usr/local/etc/mysql

Instead of

/etc/mysql

This is where you can change the bind-address = 127.0.0.1 to bind-address = 0.0.0.0, to allow all access, including from a remote server (important if you’re working from a remote server).

Accessing mysql from the cli

mysql -u root -p

Restarting the sql server

This is helpful especially after you’ve made some changes to the users and/or configuration.

brew services restart mysql