Install Database

To use Ticaga we need a database, we recommend MYSQL, to install MySQL just run the following:

sudo apt install mysql-server -y

Now we need to start and enable the MySQL service just like Apache:

sudo systemctl start mysql && sudo systemctl enable mysql

Now you can run the MySQL installation set-up:

sudo mysql_secure_installation

This loads the installation for MySQL, find out more and the questions here.

Time to create the database and user for Ticaga:

mysql -u root -p

Enter your root password, or the new password you created in the last step.

CREATE DATABASE ticaga;
CREATE USER 'ticaga_user'@'localhost' IDENTIFIED BY 'p@s3w0r$2024!';
GRANT ALL PRIVILEGES ON ticaga.* TO 'ticaga_user'@'localhost';
FLUSH PRIVILEGES;
exit;

ticaga = MySQL Database Name

ticaga_user = MySQL Username

p@s3w0r$2024! = MySQL Password (Please don't use this)

ticaga.* = Database name and wildcard. (You need the .*)

ticaga_user = MySQL Username

Congratulations you've now got the database ready.