MySQL Quickstart

The code base expects a MySQL connection to run.

MySQL Server

• Download and install MySQL Community Server for your OS.
• This will allow you to run a local MySQL server.

MySQL Workbench

• Download MySQL Workbench for your OS.
• This will allow you to connect to either a local or remote MySQL server.
• This will also allow you to create a schema for your local tamarisk database.

Create a new connection

• In MySQL Workbench, create a new connection with the following:
  • hostname 127.0.0.1 (your local IP address)
  • port 3306
  • username root
  • password leave this blank, as MySQL defaults an (insecure) root user with no password

Create a new schema

1. Connect as the root user by double clicking the newly created connection.

2. In the left drawer where it lists SCHEMAS, right click and select Create Schema... from the dropdown menu.

3. Name the schema tamariskdb and click Apply to open the create schema wizard.

4. Leave the defaults and click Apply and Finish to create the schema.

5. If you do not see the newly created tamariskdb schema listed in the SCHEMAS drawer than click the refresh icon.

6. Go back to the MySQL Workbench home by clicking the tab with the house icon.

7. Right click your connection and click Edit Connection...

8. Add the tamariskdb schema to the Default Schema option.

9. (Optional) It is good security practice to create a root password.

https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

install homebrew install mysql start mysql server $ brew services start mysql myysql -u root create user with password and grant privileges