Error in database connection [SOLVED]

[Steve Joms]

Hi All,

 

Does anyone here encountered this problem? 

 

Link to database cannot be established: SQLSTATE[HY000] [2003] Can't connect to MySQL server

 

Im using AWS server for my website and as per running a test connections I have a successful result using ssh in EC2 instance connecting to my Database and also using Mysql workbench. Only I am receiving that error when Im accessing my URL I used same credentials on running that test with my settings.inc.php

 

Should I edit this portion also?

 

define('_COOKIE_KEY_

define('_COOKIE_IV_

 

Hope you could help me with this.

 

Thanks!

Edited August 30, 2016 by joms (see edit history)

[NemoPS]

Did it happen all of a sudden, or just never worked? The site's IP might be blacklisted on aws

[Steve Joms]

Hi,

 

No I upgraded my EC2 Instance. Then I get support from AWS about it and we run a test connection anything that is on AWS and they say that the issue is in the Application side.

[shokinro]

The error is related connection between server and database server. If it is not on the same server, make sure you have correct database connection info in file /config/settings.inc.php, especially the 

 

define('_DB_SERVER_', '127.0.0.1');

define('_DB_NAME_', 'yourdbname');

define('_DB_USER_', 'yourdbuser');

define('_DB_PASSWD_', 'yourpassword');