Prepare the MySQL database

Zenario requires a minimum of MySQL 5.7.

(At the time of writing, Zenario won't work with MariaDB.)

Go into the mysql console, and create the database and user for Zenario:

$ sudo mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.26-0ubuntu0.20.04.2 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE zenariosite_90;
Query OK, 1 row affected (0.01 sec)

mysql> CREATE USER 'zenario_user'@'localhost' IDENTIFIED BY '[some-password]';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL on zenariosite_90.* to 'zenario_user'@'localhost';
Query OK, 0 rows affected (0.00 sec)

The above assumes that you have root access and can create a database yourself. If your database is managed in a different way (e.g. via a web-based system), create the database and user in that way.

If your database is not on the same server as Apache, you will need to replace localhost with the private IP address of your Apache server.

Note that we recommend putting the Zenario version within the database name so for example ending in _90 for Zenario 9.0. This can help with upgrades.