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
or maybe there is instrctuin without this problem.
mjw
January 29, 2023, 9:08pm
4
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
mjw
January 30, 2023, 5:53pm
8
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
mjw
January 30, 2023, 8:05pm
10
It’s good to read that you have solved the issue. However, it would be helpful if you shared the solution here. Thanks.