Postingan lainnya
error SQLSTATE[HY000] [2002] Connection refused pada saat di hosting
error nya muncul ketika mencoba login pada saat project sudah diupload di hosting, ketika di localhost baik2 saja tidak muncul error seperti itu, mohon bantuan nya gan.
berikut code pada .env
APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:irIxCYLbeA8ogo9n/AU0bTjkxpi8djk7kbRVxZfyKUc=
APP_DEBUG=true
APP_LOG_LEVEL=debug
APP_URL=http://localhost
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret
BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379
MAIL_DRIVER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
dan ini code pada database.php
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', 'localhost'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'inidatabase'),
'username' => env('DB_USERNAME', 'user21'),
'password' => env('DB_PASSWORD', 'user123'),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
],
Terima kasih.
3 Jawaban:
Sepertinya config yg di file .env nya blum sesuai dgn database yg di hosting
#cmiiw
Jawaban Terpilih
di file .env
DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=homestead DB_USERNAME=homestead DB_PASSWORD=secret
ganti dengan settingan dihostingnya gan..
solved gan, ternyata password database nya salah hehe, thank you :)