Langsung ke konten utama

Postingan

Menampilkan postingan dari Agustus, 2020

Membuat SSH Key Untuk Github

Photo by Kari Shea on Unsplash Jika kita sering menggunakan repositori remote seperti Github, SSH key akan sangat berguna karena kita tidak perlu memasukkan username dan password ketika kita akan melakukan push  ke Github. Berikut cara konfigurasi SSH key untuk Github dari nol (saat belum punya SSH key) : 1. Membuat SSH key dengan perintah ssh-keygen -t rsa -b 4096 -C "your_email@example.com" nanti akan ditanya soal nama file  dan passphrase  yang diinginkan, diabaikan saja dengan menekan enter  agar disetting nama dan passphrase  nya dengan dengan settingan default 2. Aktifkan SSH key eval "$(ssh-agent -s)" 3. Tambahkan SSH key ke ssh-agent ssh-add ~/.ssh/id_rsa 4. Copy SSH key dengan xclip (install xclip jika belum punya) sudo apt install xclip xclip -sel clip < ~/.ssh/id_rsa.pub 5. Masuk ke Github, di pojok kanan atas klik foto profil kita, klik menu Settings 6. Klik menu SSH and GPG Keys , lalu klik tombol New SSH Key 7. Paste kan SSH key yang sudah di...

Laravel Migrate Error : Could not find driver and no [PDOException] problem

Photo by Tianyi Ma on Unsplash I found problem when i want to migrating in Laravel, the error said [Illuminate\Database\QueryException] could not find driver (SQL: select * from information_schema.tables where table_schema = belajarlaravel and table_name = migrations i searched the solution, but almost all of forum have a problem with PDOException, which means they have to install php-mysql (for connecting between php and mysql) and set up php.ini. But my php-mysql already installed so what i have to do is set up my php.ini. Here what i did : 1. Go to /opt/lampp/etc/ 2. edit php.ini  using sudo gedit php.ini 3. find  extension=php_pdo_mysql.dll, remove the semicolon and save 4. Restart the web server When i tried to migrating again with php artisan migrate , i found new error [Illuminate\Database\QueryException] SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = belajarlaravel and table_name = migrations and table_type...

[SOLVED] #1558 - Column count of mysql.proc is wrong. Expected 21, found 20.

Photo by ClĂ©ment H on Unsplash When i imported a database, i got problem with the error said  After i search the solution on the internet, i found a simple solution. If you are using Xampp with MariaDB server. Here what you need to do : 1. Open terminal, go to opt/lampp/bin directory 2. Do upgrade with mysql_upgrade command. Enter the password, wait untill the upgrade is done That's it ! it works for me, now i can import my database