How to set-up a database for Blesta via SSH? Print

Log into MySQL / MariaDB with mysql or if you have set a root password: mysql -u root -u

CREATE DATABASE database_name;
CREATE USER ‘database_user’@‘localhost' IDENTIFIED BY ‘Your_Password';
GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost' IDENTIFIED BY 'Your_Password';
FLUSH PRIVILEGES;