MySQL Quickstart - marod424/tamarisk GitHub Wiki

The code base expects a MySQL connection to run.

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.

(Optional) Create a password for the root user

It is good practice, and more secure, to create a root password.

  1. Connect as the root user and execute the following lines of code
  2. Select the Server > Users and Privileges dropdown.
  3. Select the root account and add a custom Password.

(Optional) Create a new user

It is good practice, and more secure, to create a new user for your tamariskdb schema connection, setting aside the root user for more general admin purposes.

  1. Connect as the root user and execute the following lines of code
  2. Select the Server > Users and Privileges dropdown.
  3. Click the Add Account button and create a custom Login Name and Password.