> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/connectors/mariadb-connector-r2dbc/using-the-spring-data-framework-with-mariadb-connector-r2dbc/setup-for-connector-r2dbc-examples-spring-data.md).

# Setup for Connector/R2DBC Examples (Spring Data)

## 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:

```sql
CREATE DATABASE IF NOT EXISTS test;
```

## Create the User

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

```sql
CREATE USER 'connr2dbc_test'@'192.0.2.50'
   IDENTIFIED BY 'db_user_password';
```

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

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

<sub>*This page is: Copyright © 2025 MariaDB. All rights reserved.*</sub>

{% @marketo/form formId="4316" %}