Install ghost on ubuntu 22.04
$sudo apt update -y && sudo apt upgrade -y
$sudo apt install nginx -y
$sudo apt install mysql-server -y
$systemctl start mysql.service && systemctl enable mysql.service
$mysql
CREATE USER 'ghost'@'localhost' IDENTIFIED BY 'YourStrongPasswordHere';
CREATE DATABASE ghost;
GRANT ALL PRIVILEGES