Setup for Examples

Set up the test database and user account required by MariaDB Connector/C code examples, including schema creation SQL and privilege grants for db_user.

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

Create the Schema

Create the example database and table:

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 the User

Create a user db_user with privileges to execute the examples:

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;

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.}