Guest User

Untitled

a guest
Sep 4th, 2018
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. 'mysql' => [
  2. 'driver' => 'mysql',
  3. 'host' => env('DB_HOST', 'mysql'),
  4. 'port' => env('DB_PORT', '3306'),
  5. 'database' => env('DB_DATABASE', 'notes'),
  6. 'username' => env('DB_USERNAME', 'notes'),
  7. 'password' => env('DB_PASSWORD', 'asf9#89hf9384h'),
  8. 'unix_socket' => env('DB_SOCKET', ''),
  9. 'charset' => 'utf8mb4',
  10. 'collation' => 'utf8mb4_unicode_ci',
  11. 'prefix' => '',
  12. 'strict' => true,
  13. 'engine' => null,
  14. ],
  15.  
  16. [mysql]
  17.  
  18. [mysqld]
  19. default_authentication_plugin= mysql_native_password
  20.  
  21. DB_CONNECTION=mysql
  22. DB_HOST=mysql
  23. DB_PORT=3306
  24. DB_DATABASE=notes
  25. DB_USERNAME=notes
  26. DB_PASSWORD=asf9#89hf9384h
  27.  
  28. > IlluminateDatabaseQueryException : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = notes and table_name = migrations)
  29.  
  30. at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
  31. 660| // If an exception occurs when attempting to run a query, we'll format the error
  32. 661| // message to include the bindings with SQL, which will make this exception a
  33. 662| // lot more helpful to the developer instead of just the database's errors.
  34. 663| catch (Exception $e) {
  35. > 664| throw new QueryException(
  36. 665| $query, $this->prepareBindings($bindings), $e
  37. 666| );
  38. 667| }
  39. 668|
  40.  
  41. Exception trace:
  42.  
  43. 1 PDOException::("PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]")
  44. /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
  45.  
  46. 2 PDO::__construct("mysql:host=mysql;port=3306;dbname=notes", "notes", "asf9#89hf9384h", [])
  47. /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
  48.  
  49. Please use the argument -v to see more details.
  50.  
  51. 'default' => env('DB_CONNECTION', 'mysql'),
  52. 'mysql' => [
  53. 'driver' => 'mysql',
  54. 'host' => env('DB_HOST', '127.0.0.1'),
  55. 'port' => env('DB_PORT', '3306'),
  56. 'database' => env('DB_DATABASE', 'forge'),
  57. 'username' => env('DB_USERNAME', 'forge'),
  58. 'password' => env('DB_PASSWORD', ''),
  59. 'unix_socket' => env('DB_SOCKET', ''),
  60. 'charset' => 'utf8mb4',
  61. 'collation' => 'utf8mb4_unicode_ci',
  62. 'prefix' => '',
  63. 'strict' => true,
  64. 'engine' => null,
  65. ],
  66.  
  67. DB_CONNECTION=mysql
  68. DB_HOST=127.0.0.1
  69. DB_PORT=3306
  70. DB_DATABASE={{Database}}
  71. DB_USERNAME={{username}}
  72. DB_PASSWORD={{password}}
Add Comment
Please, Sign In to add comment