Prerequisites for Connecting Graphweaver with MySQL

In this guide, we are going to cover how to get Graphweaver and MySQL connected.

Before we dive in, let’s make sure that you have MySQL, Node.js version 18 or greater, and pnpm version 8 or greater installed on your local machine.

Once these are installed, we can get started.

Step 1: Installing and Configuring MySQL

The first step is to make sure that we have the configuration settings correct in MySQL. For this guide, we are going to assume that you have MySQL running locally on port 3306.

If you have it running on another port then remember to change this in the Graphweaver configuration below.

Next you are going to need a user in MySQL that we can use when connecting from Graphweaver. For this guide we are going to assume that you have a user root and a password of password.

Here are the settings that we will need:

• user: root
• password: 'password'
• port: 3306

Next, let’s setup a database to use as an example.

Step 2: Creating a Database

For this guide, we are going to create a database with a single table. We will be using a number of the MySQL command line tools to create the DB, create a user table and seed with some data.

Don’t worry if you prefer to use a GUI when setting up the DB. As long as the names match, you can use any tool you need.

Make sure that you have the mysql shell client installed on your local before moving on.