Database Setup

This page contains technical information about the database engines and connection methods used by the software. For guides on creating the necessary MySQL database and user credentials on your server, please refer to Installing WHMCS.

MySQL

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

A MySQL database is what WHMCS uses to store all of the data your WHMCS system controls.

MySQL is the only supported database engine by WHMCS at this time.

Strict SQL Mode

MySQL Strict Mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE.

WHMCS requires MySQL strict mode to be turned off in order for it to function.

For more information on SQL Modes, and how to set the SQL Mode for your MySQL environment, please refer to MySQL's official documentation available at the url below.

https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html

PDO

PHP Data Objects, or PDO for short, is a database access layer that provides a uniform method of access to multiple databases.

As of WHMCS 6.0, PDO became a system requirement for running WHMCS.

In WHMCS 6.0 and later, the PHP environment in which you run WHMCS must support PDO. This requires the loading of two PHP extensions in your PHP environment:

• PDO
• PDO_MYSQL

For more information, please refer to http://php.net/manual/en/ref.pdo-mysql.php