Setup for Examples

This page is part of MariaDB's Documentation.

The parent of this page is: MariaDB Connector/C++

Topics on this page:

Overview
Create the Schema
Create the User
- Password Guidance

Overview

Examples in this MariaDB Connector/C++ documentation depend on a database test and table contacts.

Create the Schema

Create a test database if one does not exist with the CREATE DATABASE CREATE DATABASE statement:
```
CREATE DATABASE IF NOT EXISTS test;
```

Create tables in the test database for testing basic and advanced operations with CREATE TABLE CREATE TABLE statements:

CREATE TABLE test.contacts (
   id INT PRIMARY KEY AUTO_INCREMENT,
   first_name VARCHAR(25),
   last_name VARCHAR(25),
   email VARCHAR(100)) ENGINE=InnoDB;

Create the User

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

CREATE USER IF NOT EXISTS 'db_user'@'192.0.2.1'
    IDENTIFIED BY 'db_user_password';

Ensure that the user account has privileges to access the tables with the GRANT GRANT statement:
```
GRANT ALL PRIVILEGES
   ON test.*
   TO 'db_user'@'192.0.2.1';
```

Password Guidance

Passwords should meet your organization's password policies. If your MariaDB Enterprise Server instance has a password validation plugin installed, the password must also meet the configured requirements.

By default, MariaDB Enterprise Server installs the simple_password_check plugin, configured with system variables: