Common recent report - you just upgraded to node 18, right? If so, check this thread:
If that’s not it, I’d start by investigating whether mysql is running. But start with the link above. I’m betting that’s it, because I see Ghost trying to connect to the ipv6 address… which is a change from Node 16.
Looks like a root+mysql password error? You can run sudo mysql -p to get it to ask for the root password.
You can also look in the config.production.json for the user/password your blog is using to login to MySQL - and mysql -u [ghost-user] -p and enter the config password to confirm Ghost can connect to the db.
To see the status of MySQL sudo systemctl status mysql and check that it is Active.
To see if MySQL is actually running, sudo netstat -leapn | less shows all listening services on your host - if you see 127.0.0.1:3306 then MySQL is up and running.
I have the acces and I tried with the pass, but still no: -bash: syntax error near unexpected token `)’
sudo systemctl status mysql
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Sun 2023-11-05 20:24:29 UTC; 1 day 6h ago
Process: 720 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 816 (mysqld)
Status: “Server is operational”
Tasks: 38 (limit: 2309)
CPU: 13min 38.881s
Nov 05 20:24:21 Bilbord systemd: Starting MySQL Community Server…
Nov 05 20:24:29 Bilbord systemd: Started MySQL Community Server.