Try to update node to install ghost 5.71.1

[William_Seldon]

Hi guys !
I use digitalOcean for ghost blog self hosting. It’s a 1click install.
It uses NodeJS 16.x.
How do you do to update nodeJS to 18.x
I tried the tutorial on the Ghost website, but it failed.
I also tried this but Ghost doesn’t start.
I saw an issue about a database connection.
Is there someone to help me ?

[Cathy_Sarisky]

So a difference between Node 16 and 18 is whether they use IPv4 vs 6 preferentially. You probably have your database only on IPv4, but Node is trying to connect to it on IPv6. Here’s the fix:

Upgrade ghost 5.71.0 with node 18, encountered error

Node 18 prefers ipv6 resolution over ipv4 - you can see this in the error message with the MySQL connection ::1:3306. If your MySQL server isn’t listening on the ipv6 interface then node won’t be able to connect to it. Quickest fix is probably explicitly specifying 127.0.0.1 for your database host in place of localhost in your Ghost config.