Prepare the MySQL database

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

Note that it's good convention to put the version number after the database name, so "105" refers to version 10.5.

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 8
Server version: 8.0.45-0ubuntu0.24.04.1 (Ubuntu)

Copyright (c) 2000, 2026, 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_105;
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_105.* 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.