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
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>
sudah bikin tabel db_laravel nya? kalo belum dibuat dulu di phpmyadminnya.
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(); }); }