# 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 **@** character , otherwise the connection won't work successfully
{% endhint %}

![](https://3029697330-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MI0UPXcjkPiqrwxCiOn%2F-MJDgaCzooaVqHy1MjQy%2F-MJGvSEmJo8gNEl0QqLM%2Fdb_creation.png?alt=media\&token=298a7ffd-ad1d-4b09-8865-4f0887c4aae4)