Prepare the MySQL database

You will need to create a database for Zenario, and a user account.

If you have command line root access, or some other access that allows you to create a database, do as follows:

$ 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_102;
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_102.* to 'zenario_user'@'localhost';
Query OK, 0 rows affected (0.00 sec)

Replace [some-password] with a strong password, and keep a note of this.

You may need to replace localhost with the IP address of your Apache server, if Apache isn't on the same server as MySQL.

If your database is managed in a different way (e.g. via a browser-based interface like phpMyAdmin), create the database and user in that way.

Database naming

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