Setup for Examples

The examples in this MariaDB Connector/R2DBC documentation depend on a database test and table contact.

Create the Schema

  1. Create a test database if one does not exist with the CREATE DATABASE statement:

    CREATE DATABASE IF NOT EXISTS test;
    
  2. Create an example table test.contact with the CREATE TABLE statement:

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

Create the User

  1. Create a user account to test connectivity with the CREATE USER statement:

    CREATE USER 'connr2dbc_test'@'192.0.2.50'
       IDENTIFIED BY 'passwd';
    
  2. Ensure that the user account has privileges to access the tables with the GRANT statement:

    GRANT ALL PRIVILEGES
       ON test.*
       TO 'connr2dbc_test'@'192.0.2.50';