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
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 pimcore charset=utf8mb4;"
Permissions needed for Pimcore
Pimcore requires all permissions on database level, that means the following:
CREATE DATABASE `project_database` charset=utf8mb4; CREATE USER 'project_user'@'%' IDENTIFIED BY 'PASSWORD'; GRANT USAGE ON *.* TO 'project_user'@'%'; GRANT ALL ON `project_database`.* TO 'project_user'@'%' WITH GRANT OPTION;