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

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',''));

Your database password should not contain the @ character , otherwise the connection won't work successfully