Version: Edit on GitHub

Database Setup

Pimcore requires a standard MySQL database, the only thing you should assure is that the database uses utf8mb4 as character set.
If you create a new database just set the character set to utf8mb4.

Note: You have to create the database manually before you can continue with the web-based installer, which automatically creates the underlying database schema for Pimcore.

Command to Create a new Database

mysql -u root -p -e "CREATE DATABASE project_database charset=utf8mb4;"

Permissions needed for Pimcore

Pimcore requires all permissions on database level. You can create a user with the necessary rights with the following commands:

CREATE USER 'project_user'@'localhost' IDENTIFIED BY 'PASSWORD';
GRANT ALL ON `project_database`.* TO 'project_user'@'localhost';

Database Server Configuration (Optional)

While setting up the MySQL Server you can enforce utf8mb4 character set and lower case table names by placing a pimcore.cnf file with the following contents into the server config directory (e.g. /etc/mysql/conf.d/). Refer to the server configuration manual applicable to your environment to determine the location of the server config directory.

# MySQL Server configuration for Pimcore.
# @See https://dev.mysql.com/doc/refman/8.0/en/option-files.html
# @See https://pimcore.com/docs/6.x/Development_Documentation/Installation_and_Upgrade/System_Setup_and_Hosting/DB_Setup.html

# Applies to any client connecting to this sever
[client]
default-character-set=utf8mb4

# Applies to mysql cli client application
[mysql]
default-character-set=utf8mb4

# Applies to mysql server
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
lower_case_table_names=1

Setting lower_case_table_names=1 makes sure that tables for Pimcore classes are created in lower case even though their class names contain capital letters. Starting with MySQL 8, you can no longer set the lower_case_table_names option after the data directory has been initialized. If the directory was already initialized with a different lower_case_table_names setting, MySQL will fail to start (Different lower_case_table_names settings for server and data dictionary). To fix this, place the pimcore.cnf file in the config directory, remove the MySQL data directory and run mysqld --initialize. This will delete all databases, so backup the existing databases with mysqldump before deleting the data directory.

rm -rf /var/lib/mysql
mkdir /var/lib/mysql
chown mysql:mysql /var/lib/mysql
mysqld --initialize