SQLSTATE[HY000] [2002] Connection refused - Caused by: PDOException

Question

I have the following settings in config/db.php:

return [
    'class' => 'yii\db\Connection'
    'dsn' => 'mysql:host=myURL;dbname=mydb', 
    'username' => 'mydbUsername',
    'password' => 'mydbPassword',
    'charset' => 'utf8',
];

That above string works in my test-machine, however in the server where I deployed the app does not work.

What is wrong? Thanks.

What exception? Your question doesn.t point nothing. And you paste some array, not the connection setting. Please improve question, for now it doesn't make sense — michalczukm, Jan 30 '15 at 03:24

score -1 · Accepted Answer · answered Jan 30 '15 at 04:19

-1

host=myURL ?? try host=localhost

Unless you are using a different machine for the mysql server, but I guess you are not.

answered Jan 30 '15 at 04:19

Mihai P.

9,307
3
38
49

My issue is when I deploy the app into a server, for some reason I cannot connect the DB in the remote-server. Thanks – Jan Beeck Jan 30 '15 at 13:17
Is MySQL onyour remote server configured to accept remote connections? – pritaeas Jan 30 '15 at 15:20
My mistake was that I put the URL as the host. I worked with host=server IP. Thanks – Jan Beeck Jan 30 '15 at 18:33

score -1 · Answer 2 · answered Jan 30 '15 at 15:14

-1

If you have different host name, then try chaning host name. But i think the connection is refused because, you are trying to access your mysql server with different port number.

Try with this:

 mysql:host=hostName;dbname=dbName;port=portNumber;

answered Jan 30 '15 at 15:14

tnchalise

1,573
2
18
38

score -1 · Answer 3 · answered Aug 17 '20 at 09:31

-1

You can also check the php-mysql module install on your server.

apt-get install php-mysql

answered Aug 17 '20 at 09:31

Akshay Singhal

1
4

SQLSTATE[HY000] [2002] Connection refused - Caused by: PDOException

3 Answers3