✖ Setting up "ghost" mysql user fails + droplet

Ghost installation fails the mysql setup

i tried 5+ times, always same.

any idea? thank you!

✖ Setting up “ghost” mysql user

---

✔ Checking system Node.js version - found v18.17.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.85.1

✔ Finishing install process

? **Enter your blog URL:** https://mydomain.com

✔ Configuring Ghost

✔ Setting up instance

+ sudo useradd --system --user-group ghost

+ sudo chown -R ghost:ghost /var/www/ghost/content

✔ Setting up "ghost" system user

**✖ Setting up "ghost" mysql user**

+ sudo mv /tmp/mydomain-com/mydomain.com.conf /etc/nginx/sites-available/mydomain.com.conf

+ sudo ln -sf /etc/nginx/sites-available/mydomain.com.conf /etc/nginx/sites-enabled/mydomain.com.conf

+ sudo nginx -s reload

✔ Setting up Nginx

? **Enter your email (For SSL Certificate)** hello@mydomain.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 mydomain.com --webroot /var/www/ghost/system/nginx-root --reloadcmd "nginx -s reload" --accountemail hello@mydomain.com --keylength 2048

+ 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/mydomain-com/mydomain.com-ssl.conf /etc/nginx/sites-available/mydomain.com-ssl.conf

+ sudo ln -sf /etc/nginx/sites-available/mydomain.com-ssl.conf /etc/nginx/sites-enabled/mydomain.com-ssl.conf

+ sudo nginx -s reload

✔ Setting up SSL

+ sudo mv /tmp/mydomain-com/ghost_mydomain-com.service /lib/systemd/system/ghost_mydomain-com.service

+ sudo systemctl daemon-reload

✔ Setting up Systemd

+ sudo systemctl is-active ghost_mydomain-com

+ sudo systemctl start ghost_mydomain-com

+ sudo systemctl stop ghost_mydomain-com

✖ Starting Ghost

One or more errors occurred.



1) ConfigError



Error detected in the production configuration.



Message: connect ECONNREFUSED 127.0.0.1:3306

Configuration Key(s): database.connection.host / database.connection.port

Current Value(s): 127.0.0.1 / 3306



Help: Ensure that MySQL is installed and reachable. You can always re-run `ghost setup` to try again.





2) GhostError



Message: Ghost was able to start, but errored during boot with: connect ECONNREFUSED 127.0.0.1:3306

Help: Unknown database error

Suggestion: journalctl -u ghost_mydomain-com -n 50



Debug Information:

    OS: Ubuntu, v22.04.3 LTS

    Node Version: v18.17.1

    Ghost Version: 5.85.1

    Ghost-CLI Version: 1.26.0

    Environment: production

    Command: 'ghost install --auto --db=mysql --dbhost=127.0.0.1 --dbport=3306 --dbname=ghost_production --dbuser=root --dbpass=888b26c6f701b879877afbe3c89d31b9cc06ac90ff58f346 --dir=/var/www/ghost --start'