Database

Now we've got PHP sorted, we can now sort out the database, this is where all your Ticaga tickets, departments, customers, agents will  be created, edited and removed.

Let's get started:

yum install mariadb-server -y

Now we need to enable MariaDB on the server boot, just like Apache:

sudo systemctl enable mariadb && sudo systemctl start mariadb

Now we need to get everything sorted, so let's do:

mysql_secure_installation

This loads the installation for MariaDB, 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.