Difference between revisions of "Database Setup"
(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...") |
|||
| 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]]. | ||
| + | ==MySQL== | ||
MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). | 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. | 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== | ==PDO== | ||
| Line 19: | Line 32: | ||
For more information, please refer to http://php.net/manual/en/ref.pdo-mysql.php | For more information, please refer to http://php.net/manual/en/ref.pdo-mysql.php | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 15:47, 8 May 2018
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.
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.
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