Econnrefused 127.0.0.1:3306

Hello, many times i try to install and setup ghost.

First i get troubles with Access Denied for User ‘root’@’localhost’ when i ghost start
than i do this


the problem gone, BUT I GET ANOTHER ONE
i cant fix it

is there is a way how to fix it? my SSL have 2 GB of RAM and i do all like in the install manual How to install & setup Ghost on Ubuntu 16.04, 18.04, 20.04 or 22.04

Maybe it will help

systemctl status mysql

MYSQL CONF

or maybe there is instrctuin without this problem.

Create a new database user for use with Ghost.

sudo mysql -u root -p

CREATE USER 'user_your_site@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE your_site_prod;
GRANT ALL PRIVILEGES ON your_site_prod.* TO 'user_your_site'@'localhost';
FLUSH PRIVILEGES;
QUIT;

I do it all, then i make ghost setup and fill new information, but nohing changes.

Then i try reinstall ghost and again i have the same shit

LOGS:


i even try to reinstall mySQL and reinstall ubuntu on my VPS. But nothing helped. Probably this is bug, and not only i got this

I even ADD more RAM to my VPS. And even with this - nothing work.
if u can help me - i can give SSH keys

No, it’s not a bug, it’s more likely your setup, i.e., MySQL isn’t allowing connections.

It’s unclear what OS you’re running, or the steps you followed to install Ghost and MySQL.

problem was solved. That was troubles with SQL cant connect to 127huy if someone need help with the same issute telegram: nicknotknack

It’s good to read that you have solved the issue. However, it would be helpful if you shared the solution here. Thanks.