Setup for Examples

Create the Schema

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

CREATE DATABASE IF NOT EXISTS test;

Create the User

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

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

2. Ensure that the user account has privileges to access the tables with the GRANTGRANT statement:

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