Database Error when starting ghost_ Error ID : 500, Code: EAI_AGAIN

[mjw]

@SasikaA073

I was setting up the ghost through a Youtube tutorial, I didn’t get a prompt to change the password for the root user using this command.

It’s best to start with the official guide. So, read this through first to be sure you understand. Also, note that Ubuntu 22.04 isn’t supported, even though it may work.

How to install & setup Ghost on Ubuntu 20.04 or 22.04

To attempt to recover your setup, follow this thread from this post. It will show you how to setup MySQL, and restart the installation process. You’ll need to substitute some parts with your site details.

How to install Ghost CMS on my VPS

Okay, next steps are to create a database and database user for Ghost. Type sudo mysql and you’ll see a different prompt. This is because you are using MySQL and have left the BASH command-line. You’ll need to replace <password> with your password; create a new one for this. create database boringdigital_com; create user 'user_boringdigital_com'@'localhost' identified by '<password>'; grant all privileges on boringdigital_com.* to 'user_boringdigital_com'@'localhost'; flush privileges; quit; P…