This provides all database connectivity to MySQL.
All configuration of databases are done in the config.php file, where the following directives needs to be set.
| global_database_server | The host name of the global database server |
|---|---|
| global_database_username | The user name of the global database user |
| global_database_password | The password of the global database user |
| global_database_name | The name of the global database |
| instance_database_name | The prefix of the instance databases |
The user provided in this configuration file should have full access to create new databases as it creates the instance databases. If you operate with a single instance, you can revoke these rights after you have created your instance.
You query the database using either globalQuery() for the global database or instanceQuery() for the active instance database.