SQLSTATE [HY000] [2002]连接被拒绝 - 引起：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.

Answer 1

host=myURL ?? try host=localhost

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