Powered by GitBook

1 of 1

Loading...

Setup for Connector/R2DBC Examples (Native API)

Overview

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 an example table test.contact with the CREATE TABLE statement:

Create the User

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

Ensure that the user account has privileges to access the tables with the GRANT statement:

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

CREATE DATABASE IF NOT EXISTS test;

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 USER 'connr2dbc_test'@'192.0.2.50'
   IDENTIFIED BY 'db_user_password';

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