Knowledge Base

Create a new database

CREATE DATABASE resourcespace CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ResourceSpace will automatically create database tables, indexes and so on.

Database users

It is a good security practice to create dedicated users for ResourceSpace.

Read-write access level

CREATE USER 'resourcespace_rw'@'localhost' IDENTIFIED BY 'your_rw_password';
GRANT ALL PRIVILEGES ON resourcespace.* To 'resourcespace_rw'@'localhost';

Read-only access level

CREATE USER 'resourcespace_r'@'localhost' IDENTIFIED BY 'your_r_password';
GRANT SELECT ON resourcespace.* To 'resourcespace_r'@'localhost';

IMPORTANT Please make sure to change the passwords given as an example above.