Setup for Examples

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

Create the Schema

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

CREATE DATABASE IF NOT EXISTS test;

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';