Database Basics

Database/Table Collation

You must ensure that the collation of your database, tables and columns is the same!

A difference in collation between tables can occur, e.g., when the database server has been switched. The database server defines the "default collation" used unless otherwise specified. If the collation is not the same across at least the tables listed below, FiveNet's database migrations have a very high likely hood of failing due to that.

To check the collation of your database tables, you can use the following SQL queries:

USE `__YOUR_DATABASE_NAME_HERE__`;
SHOW TABLE STATUS;

Changing the database, table, column Collation

I personally have used How to easily convert utf8 tables to utf8mb4 in MySQL 5.5 - Database Administrators Stack Exchange, but, as pointed out by the comments, with SET foreign_key_checks = 0; before you would run the generated queries and SET foreign_key_checks = 1; after you ran the generated queries.

Creating Database User

These are sample queries to create a database user named fivenet with "full" access to the database (database_name). You are expected to change the password in the first query and specify the right database name in the GRANT query second line.

CREATE USER 'fivenet'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON `database_name`.* TO 'fivenet'@'%';