Postingan lainnya

Tidak Bisa Konek di MySQL

Malam gan mau nanya

saya mau migrate db saya ke database mysql tetapa kog gagal ya, padahal setingan .env nya uda bener.

errornya seperti ini gan

 C:\xampp\htdocs\LaravelApp>php artisan migrate

In Connection.php line 664:

  SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from informa
  tion_schema.tables where table_schema = db_laravel and table_name = migrations)

In Connector.php line 67:

  SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

In Connector.php line 67:

  PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]

script .env

 APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:4b5Uls3jVSJQIXDjLqrPumpXw5NPH4fsdyq3Jme5atI=
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=db_laravel
DB_USERNAME=root
DB_PASSWORD=rahasia

BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
SESSION_LIFETIME=120
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=
PUSHER_APP_CLUSTER=mt1

mohon pencerahanya

laravel

@ardakusuma

50 Kontribusi 4 Poin

Diperbarui 5 tahun yang lalu

3 Jawaban:

coba cek ini <a href='https://github.com/laradock/laradock/issues/1392#issuecomment-368308494 '>https://github.com/laradock/laradock/issues/1392#issuecomment-368308494 </a>

@gunalirezqimauludi

350 Kontribusi 243 Poin

Dipost 5 tahun yang lalu

sudah bikin tabel db_laravel nya? kalo belum dibuat dulu di phpmyadminnya.

@saferagic

4 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

coba liat migrationnya kyk gimana..

@bosque

187 Kontribusi 104 Poin

Dipost 5 tahun yang lalu

Tanggapan

public function up() { Schema::create('siswa', function (Blueprint $table) { $table->increments('id'); $table->string('nisn', 4)->unique(); $table->string('nama_siswa', 30); $table->date('tgl_lahir'); $table->enum('jenis_kelamin', ['L', 'P']); $table->timestamps(); }); }

@ardakusuma