Now I get this error after reseting my vps and starting with a fresh os.
web@website:/var/www/home$ ghost install
Love open source? We’re hiring JavaScript Engineers to work on Ghost full-time.
https://careers.ghost.org
✔ Checking system Node.js version - found v16.19.1
✔ Checking current folder permissions
✔ Checking memory availability
✔ Checking free space
✔ Checking for latest Ghost version
✔ Setting up install directory
✔ Downloading and installing Ghost v5.43.0
✔ Finishing install process
? Enter your blog URL: https://aidan-a.me
? Enter your MySQL hostname: localhost
? Enter your MySQL username: web-root
? Enter your MySQL password: [hidden]
? Enter your Ghost database name: home_prod
✔ Configuring Ghost
✔ Setting up instance
+ sudo useradd --system --user-group ghost
+ sudo chown -R ghost:ghost /var/www/home/content
✔ Setting up "ghost" system user
ℹ Setting up "ghost" mysql user [skipped]
? Do you wish to set up Nginx? Yes
+ sudo mv /tmp/aidan-a-me/aidan-a.me.conf /etc/nginx/sites-available/aidan-a.me.conf
+ sudo ln -sf /etc/nginx/sites-available/aidan-a.me.conf /etc/nginx/sites-enabled/aidan-a.me.conf
+ sudo nginx -s reload
✔ Setting up Nginx
? Do you wish to set up SSL? Yes
? Enter your email (For SSL Certificate) legotrain2008@gmail.com
+ sudo mkdir -p /etc/letsencrypt
+ sudo ./acme.sh --install --home /etc/letsencrypt
+ sudo /etc/letsencrypt/acme.sh --issue --home /etc/letsencrypt --server letsencrypt --domain aidan-a.me --webroot /var/www/home/system/nginx-root --reloadcmd "nginx -s reload" --accountemail legotrain2008@gmail.com
+ sudo openssl dhparam -dsaparam -out /etc/nginx/snippets/dhparam.pem 2048
+ sudo mv /tmp/ssl-params.conf /etc/nginx/snippets/ssl-params.conf
+ sudo mv /tmp/aidan-a-me/aidan-a.me-ssl.conf /etc/nginx/sites-available/aidan-a.me-ssl.conf
+ sudo ln -sf /etc/nginx/sites-available/aidan-a.me-ssl.conf /etc/nginx/sites-enabled/aidan-a.me-ssl.conf
+ sudo nginx -s reload
✔ Setting up SSL
? Do you wish to set up Systemd? Yes
+ sudo mv /tmp/aidan-a-me/ghost_aidan-a-me.service /lib/systemd/system/ghost_aidan-a-me.service
+ sudo systemctl daemon-reload
✔ Setting up Systemd
+ sudo systemctl is-active ghost_aidan-a-me
? Do you want to start Ghost? Yes
+ sudo systemctl start ghost_aidan-a-me
+ sudo systemctl stop ghost_aidan-a-me
✖ Starting Ghost
One or more errors occurred.
1) GhostError
Message: Ghost was able to start, but errored during boot with: Access denied for user 'web-root'@'localhost' (using password: YES)
Help: Unknown database error
Suggestion: journalctl -u ghost_aidan-a-me -n 50
Debug Information:
OS: Ubuntu, v22.04.2 LTS
Node Version: v16.19.1
Ghost Version: 5.43.0
Ghost-CLI Version: 1.24.0
Environment: production
Command: 'ghost install'
Additional log info available in: /home/web/.ghost/logs/ghost-cli-debug-2023-04-13T14_11_19_982Z.log
Try running ghost doctor to check your system for known issues.
You can always refer to https://ghost.org/docs/ghost-cli/ for troubleshooting.
web@website:/var/www/home$ cd
web@website:~$ journalctl -u ghost_aidan-a-me -n 50
Hint: You are currently not seeing messages from other users and the system.
Users in groups 'adm', 'systemd-journal' can see all messages.
Pass -q to turn off this notice.
-- No entries --
web@website:~$ cd /var/www/home
web@website:/var/www/home$ ghost doctor
Love open source? We’re hiring JavaScript Engineers to work on Ghost full-time.
https://careers.ghost.org
✔ Checking system Node.js version - found v16.19.1
✔ Checking logged in user
✔ Ensuring user is not logged in as ghost user
✔ Checking if logged in user is directory owner
✔ Checking current folder permissions
✔ Checking system compatibility
✔ Checking for a MySQL installation
+ sudo systemctl is-active ghost_aidan-a-me
+ sudo systemctl reset-failed ghost_aidan-a-me
✔ Validating config
✔ Checking folder permissions
✔ Checking file permissions
✔ Checking content folder ownership
✔ Checking memory availability
✔ Checking binary dependencies
✔ Checking free space
✔ Checking systemd unit file
✔ Checking systemd node version - found v16.19.1
web@website:/var/www/home$