SQLSTATE[HY000] [1045] 用户 'username'@

Question

我知道这个问题有很多类似的问题，但没有一个能帮助我解决这个问题。我正在尝试将我的 EC2 实例上的 laravel 项目连接到我的 RDS 实例。我可以成功连接到 RDS 实例并在我使用时创建表：mysql -h ....rds.amazonaws.com -u cmadmin -p但是，我目前在运行时遇到以下错误php artisan migrate：In Connection.php line 664:  SQLSTATE[HY000] [1045] Access denied for user 'cmadmin'@'ec2_privateIP' (using password: YES) (SQL: select * from information_schema.tables where table_schema = dbname_cm and table_name = migrations)In Connector.php line 67:  SQLSTATE[HY000] [1045] Access denied for user 'cmadmin'@'ec2_privateIP' (using password: YES)这是 .env 文件的摘录：APP_NAME=LaravelAPP_ENV=localAPP_KEY=generatedkeyAPP_DEBUG=trueAPP_LOG_LEVEL=debugAPP_URL=http://localhostDB_CONNECTION=mysqlDB_HOST=....rds.amazonaws.comDB_PORT=3306DB_DATABASE=dbname_cmDB_USERNAME=cmadminDB_PASSWORD=rfL8zvXnMEzit02这是 config/database.php 文件的摘录：'mysql' => [    'driver' => 'mysql',    'host' => env('DB_HOST', ''),    'port' => env('DB_PORT', '3306'),    'database' => env('DB_DATABASE', ''),    'username' => env('DB_USERNAME', ''),    'password' => env('DB_PASSWORD', ''),    'unix_socket' => env('DB_SOCKET', ''),    'charset' => 'utf8mb4',    'collation' => 'utf8mb4_0900_ai_ci',    'prefix' => '',    'strict' => false,    'engine' => null,    'option'  => [        PDO::MYSQL_ATTR_SSL_CA => base_path('/var/mysql-cert/dbname_cm-db.pem')    ],],我什至将以下内容添加到app/Providers/AppServiceProvider.phppublic function boot()    {       Schema::defaultStringLength(191);    }我已经运行了： php artisan cache:clear php artisan config:clear php artisan config:cachePHP 7.2.24-0ubuntu0.18.04.4 Laravel 框架 5.5.49 AWS RDS：MySQL 8.0.17mysql> SELECT USER(),CURRENT_USER();+------------------------+----------------+| USER()                 | CURRENT_USER() |+------------------------+----------------+| cmadmin@ec2_privateIP  | cmadmin@%      |+------------------------+----------------+

Answer 1

    'driver' => 'mysql',

    'host' => env('DB_HOST', ''),

    'port' => env('DB_PORT', '3306'),

    'database' => env('DB_DATABASE', ''),

    'username' => env('DB_USERNAME', ''),

    'password' => env('DB_PASSWORD', ''),

    'unix_socket' => env('DB_SOCKET', ''),

    'charset' => 'utf8mb4',

    'collation' => 'utf8mb4_0900_ai_ci',

    'prefix' => '',

    'strict' => false,

    'engine' => null,

    'option'  => [

        PDO::MYSQL_ATTR_SSL_CA => base_path('/var/mysql-cert/dbname_cm-db.pem')

    ],

],```

have you already try file this part `'username' => env('DB_USERNAME', ''),` with `'username' => env('DB_USERNAME', 'cmadmin'),`

and of course the DB_PASSWORD part with your predefined password

Answer 2

我通过在 database.php 文件中添加以下代码解决了这个问题

'mysql' = [

'sslmode' => 'require',

'options'   => array(

            PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false,

            PDO::MYSQL_ATTR_SSL_KEY => '/certs/client-key.pem',

            PDO::MYSQL_ATTR_SSL_CERT => '/certs/client-cert.pem',

            PDO::MYSQL_ATTR_SSL_CA => '/certs/ca.pem',

        )

],