Doctrine数据库连接问题

Question

Trying to connect to a dababase which is in a different server:

Command line

php symfony configure:database "mysql:host=<IP>;dbname=<db_name>" <username> <password>  

Databases.yml

  all:   
    doctrine:     
    class: sfDoctrineDatabase     
      param:       
      dsn: 'mysql:host=<IP>;dbname=<db_name>'
      username: <username>       
      password: <password>  

Getting error:

PDO Connection Error: SQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

Answer 1

You need to grant access to the user from that host. Something like

GRANT ALL ON mydb.* TO 'someuser'@'somehost';

More here.