Getting mysql connection error


#1

I’m trying to install ghost at DigitalOcean hosting,
I install Lemp stack and then trying to install ghost. I’m continuously getting connection issue of mysql.

Debug Information

OS: Ubuntu, v16.04
Node Version: v8.11.4
Ghost-CLI Version: 1.9.2
Environment: production
Command: 'ghost setup'


#2

You Have To Create A New Mysql userName and password whiten Database And Permission Then Trying.


#3

step 1 . CREATE DATABASE db_name;

step 2 . CREATE USER ‘user_name’@‘localhost’ IDENTIFIED BY ‘user_password’;

step 3. GRANT ALL PRIVILEGES ON db_name. * TO ‘user_name’@‘localhost’;

Now Install Ghost Given The DB_NAME db_name, DB_USERNAME user_name DB_PASSWORD user_password.


#4

You may want to check that you can access mysql using your exact specified parameters through the command line if you haven’t done so already:

mysql -h localhost -u <user_name> -p <database_name>

And then enter the mysql <user_password> when prompted.


#6

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.