Getting mysql connection error

[kingrayhan]

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'

[Rubel]

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

[Rubel]

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.

[beefpatty8888]

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.