Examples in the MariaDB Connector/C++ documentation depend on a database test and table contacts.
Create a test database if one does not exist with the statement:
Create tables in the test database for testing basic and advanced operations with statements:
Create a user account to test connectivity with the statement:
Ensure that the user account has privileges to access the tables with the statement:
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:
system variables.
This page is: Copyright © 2025 MariaDB. All rights reserved.
CREATE DATABASE IF NOT EXISTS test;CREATE TABLE test.contacts (
id INT PRIMARY KEY AUTO_INCREMENT,
first_name VARCHAR(25),
last_name VARCHAR(25),
email VARCHAR(100)) ENGINE=InnoDB;CREATE USER IF NOT EXISTS 'db_user'@'192.0.2.1'
IDENTIFIED BY 'db_user_password';GRANT ALL PRIVILEGES
ON test.*
TO 'db_user'@'192.0.2.1';