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 DATABASE IF NOT EXISTS test;
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
Create a user account to test connectivity with the CREATE USER statement:
CREATE USER 'connr2dbc_test'@'192.0.2.50'
IDENTIFIED BY 'db_user_password';
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';
This page is: Copyright © 2025 MariaDB. All rights reserved.
Last updated
Was this helpful?