Setup for Connector/C++ Examples

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

Create the Schema

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

CREATE DATABASE IF NOT EXISTS test;

1. Create tables in the test database for testing basic and advanced operations with 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

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

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

1. Ensure that the user account has privileges to access the tables with the 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:

• simple_password_check_digits

• simple_password_check_letters_same_case

• simple_password_check_minimal_length

• simple_password_check_other_characters system variables.

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