> For the complete documentation index, see [llms.txt](https://mtrsolution.gitbook.io/eventic/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mtrsolution.gitbook.io/eventic/installation/database.md).

# Database

Once you are logged in your hosting provider panel, you should look for section named Databases in order to create a new database.

Please take note of the following information while creating the database:

* The host name
* The database name
* The database username
* The database password

{% hint style="danger" %}
Make sure that the **sql\_mode** system variable does not contain **ONLY\_FULL\_GROUP\_BY** as this is not compatible with Eventic

You can either remove the **ONLY\_FULL\_GROUP\_BY** manually by:

* Open up PhpMyAdmin
* Click on the Variables menu
* Scroll down to sql mode
* Click on the edit button and change the value by removing **ONLY\_FULL\_GROUP\_BY** 
* Click on save

Or by executing the following sql query:

SET GLOBAL sql\_mode=(SELECT REPLACE(@@sql\_mode,'ONLY\_FULL\_GROUP\_BY',''));
{% endhint %}

{% hint style="danger" %}
Your database password should not contain the **any special** characters besides \*, otherwise the connection won't work successfully
{% endhint %}