jonseg / crud-admin-generator

An open source tool to generate a complete backend from a MySql database.
http://crud-admin-generator.com/
MIT License
1.43k stars 441 forks source link

[Doctrine\DBAL\Exception\ConnectionException] external databse #114

Open Demonium opened 7 years ago

Demonium commented 7 years ago

I have error below: Want to connect external mysql database with below parameters

$app->register(new Silex\Provider\DoctrineServiceProvider(), array(

            'dbs.options' => array(
                    'db' => array(
                            'driver'   => 'pdo_mysql',
                            'dbname'   => 'mydatabase',
                            'host'     => 'myexternalhost',
                            'user'     => 'mydbuser',
                            'password' => 'mypassword',
                            'charset'  => 'utf8',
                    ),
            )

));

my external host has ip myexternalhost= 192.168.30.132

and when I execute php console generate:admin

I'm getting error below [Doctrine\DBAL\Exception\ConnectionException] An exception occured in driver: SQLSTATE[28000] [1045] Access denied for user 'mydbuser'@'192.168.30.133' (using pa ssword: YES)

I have change the host with the IP address nothing change