MySQL
To have launchd start MySQL now and restart at login:
Or, if you don’t want/need a background service you can just use the mysql.server
tool:
You can see the different commands available for mysql.server
with:
To connect with the command-line client, run:
Note: By default, the MySQL user has no password. It doesn’t really matter for a local development database. If you wish to change it though, you can use $ mysqladmin -u root password 'new-password'
.
It is always nice to have a GUI tool for managing databases. For Mac, you can use Sequel Pro to manage local and remote MySQL databases. It is a free tool, you can choose to donate to support the development.