我知道這個問題有很多類似的問題，但沒有一個能幫助我解決這個問題。我正在嘗試將我的 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@% |+------------------------+----------------+
2 回答
HUX布斯
TA貢獻1876條經驗 獲得超6個贊
'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
胡子哥哥
TA貢獻1825條經驗 獲得超6個贊
我通過在 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',
)
],
- 2 回答
- 0 關注
- 261 瀏覽
添加回答
舉報
0/150
提交
取消