How to connect to remote mySQL DB in Yii2

Question

I'm using Yii 2.0 basic template. I have tried to connect to the DB. The connection in local db is working. But I'm not able to connect to the remote mySQL db that is in domain server.

This is my db config:

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=smargav.com;dbname=smargavc_Konnections',
    'username' => 'smargavc_Konnect',
    'password' => '******',
    'charset' => 'utf8'
];

I'm getting error as following:

{"name":"Database Exception","message":"SQLSTATE[HY000] [1045] Access denied for user 'smargavc_Konnect'@'122.167.47.26' (using password:

vishal vasudeva · Accepted Answer · 2015-05-19 06:05:04Z

1

connection string seems fine

Several possible causes :

smargavc_Konnect user doesn't have permission to connect remotely
MYSQL is in stopped state at remote server
3306 port is not allowed in remote server
Your IP is not allowed to access the remote server using http

Check if all of these are true , you should be able to connect

answered May 19, 2015 at 6:05

vishal vasudeva

859 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Deen Over a year ago

How can i figure out these problems?

vishal vasudeva Over a year ago

try connecting using any mysql client using mysql workbench , If you are : that means all these 4 problems have fixed.

vishal vasudeva Over a year ago

For problem 1 : login to mysql using root check user table and it's access for Problem 2: login to server start mysql by sudo service mysqld start For problem 3: check if port 3306 is allowed in security group

Deen Over a year ago

This time, i uploaded yii framework into server. now im getting 500 error. Please check stackoverflow.com/questions/30340469/…

Collectives™ on Stack Overflow

How to connect to remote mySQL DB in Yii2

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related