Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

5.3 Create a "sakai" database and user account

Create the db by connecting to your db and running one of the following, depending on your db the default character set may be utf8mb3 or utf8mb4

create database <db-name> default character set 'utf8';

This becomes important if you want your database to store high order range of utf8 which is usually emoji. If using utf8mb4 you will want to set the following property to false.

content.cleaner.filter.utf8=false

Next you will want to create a user that can be used to access the db

create user 'sakai'@'localhost' identified by 'password';

Give the user full access to the db

grant all on <db-name>.* to 'sakai'@'localhost';