After create and migrate database by “php artisan migrate”, sometimes wants to manipulate database directly, especially in debug. Sequel Pro is one of the best MySQL tools for Mac. Here is a setup memo.
Guest OS: CentOS Linux release 7.4.1708 (Core)
Sequel Pro: 1.1.2
MySQL: mysql Ver 14.14 Distrib 5.6.39, for Linux (x86_64) using EditLine wrapper
1. Sequel Pro download and install
“sequel-pro-1.1.2.dmg” download will be started automatically. After completion download, double click it. Drag Sequel Pro into Application.
Click “SSH” tab and put necessity value in it. If you’d like to know setup of Laravel from scratch, check this page.
Name: “Whatever you wants”
MySQL Host: 127.0.0.1
SSH Host: 192.168.33.10 (*vagrant initial address)
SSH User: vagrant
SSH Key: Click KEY Button and choose private_key(*1) file
*1 get to know the “private_key file path(IdentityFile)” by “vagrant ssh-config” command.
3. Test connection
If input has completed, “Connect” button turns blue. Click “Test connection” button below “Connect” button. If all parameters are right, “Connection succeeded” will be display on left side of “Connect” button. Before proceed next, don’t forget save configuration. Click “Add to Favorites”.
4. Setup has been completed
If connection has been established, you can see this.
5. Check “lalavel_db” database which has been migrated
Click list button where upper left side, then choose laravel_db, In this case, I did “php artisan make:auth”. So, three tables for auth shown.
Hope this will help you 😗
- Laravel, Macbook, PHP, Sequel Pro, Vagrant