Database Error PDOException Error: SQLSTATE[HY000] [1045]

Question

I configure the website on the server getting the error, CakePHP 3 but when I point my browser to some link it gives me this errors:

Error: SQLSTATE[HY000] [1045] Access denied for user 'rapidvolley'@'localhost' (using password: YES)

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in

config/app.php.

If you want to customize this error message, create src/Template/Error/pdo_error.ctp

Rajeev Gautam · Accepted Answer · 2019-05-20 18:16:33Z

1

Fixed the issue, used the below DB hostname connection:

'Datasources' => [
        'default' => [
            'className' => 'Cake\Database\Connection',
            'driver' => 'Cake\Database\Driver\Mysql',
            'persistent' => false,
            'host' => 'localhost',     
            'username' => 'username',
            'password' => 'password ', 
            'database' => 'DB name',
            'encoding' => 'utf8',
            'timezone' => 'UTC',
            'cacheMetadata' => true,
            'quoteIdentifiers' => false,
            'log' => false,
            //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'],
            'url' => env('DATABASE_TEST_URL', null),

answered May 20, 2019 at 18:16

Rajeev Gautam

4913 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Database Error PDOException Error: SQLSTATE[HY000] [1045]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related