Database Setup - Revision history

Lawrence: Redirected page to System Environment Guide

2020-09-16T18:57:01Z

Redirected page to System Environment Guide

John at 15:47, 8 May 2018

2018-05-08T15:47:02Z

Matt: Created page with " 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 stor..."

2015-07-03T08:39:22Z

Created page with " 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 stor..."

New page

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.

==PDO==

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

<div class="docs-alert-info">As of WHMCS 6.0, PDO became a system requirement for running WHMCS.</div>

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

==Strict SQL Mode==

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

<div class="docs-alert-warning">WHMCS requires MySQL strict mode to be turned off in order for it to function.</div>

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

← Older revision		Revision as of 18:57, 16 September 2020
Line 1:		Line 1:
−	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#Creating_a_Database\|Installing WHMCS~~]].	+	#REDIRECT [[System Environment Guide]]
−
−	~~==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.~~
−
−	~~<div class="docs-alert-warning">WHMCS requires MySQL strict mode to be turned off in order for it to function.</div>~~
−
−	~~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.~~
−
−	~~<div class="docs-alert-info">As of WHMCS 6.0, PDO became a system requirement for running WHMCS.</div>~~
−
−	~~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~~

@@ Line 1: / Line 1: @@
 MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).
@@ Line 6: / Line 8: @@
 MySQL is the only supported database engine by WHMCS at this time.
 ==PDO==
@@ Line 19: / Line 32: @@
 For more information, please refer to http://php.net/manual/en/ref.pdo-mysql.php