Setup for Examples

This page is part of MariaDB's Documentation.

The parent of this page is: MariaDB Connector/Node.js

Topics on this page:

Overview
Create the Schema
Create the User

Overview

The examples in the MariaDB Connector/Node.js documentation depend on a database test and table contacts.

Create the Schema

Create a test database if one does not exist with the CREATE DATABASE CREATE DATABASE statement:
```
CREATE DATABASE IF NOT EXISTS test;
```

Create a table called contacts to test the Promise and Callback API functions:

CREATE TABLE IF NOT EXISTS test.contacts (
   id INT PRIMARY KEY AUTO_INCREMENT,
   first_name VARCHAR(25),
   last_name VARCHAR(25),
   email VARCHAR(100)
) ENGINE = InnoDB;

Create the User

Create a user account to test connectivity with the CREATE USER CREATE USER statement:
```
CREATE USER 'db_user'@'192.0.2.50'
IDENTIFIED BY 'db_user_password';
```
Ensure that the user account has privileges to access the tables with the GRANT GRANT statement:
```
GRANT ALL PRIVILEGES
ON test.*
TO 'db_user'@'192.0.2.50';
```