Level 39
Remember that when using something like Sequel pro and Homestead, you need to use the Homestead IP. 192.168.10.10 and then the credentials which is usually homestead and secret
Oct 9, 2017
3
Level 1
Homestead - cannot see database tables
I have a site running on Vagrant, I am on Mac. I use sudo to vagrant up, use vagrant ssh to go to the Code folder and then run php artisan migrate I have gone with all the defaults to try and get the database tables to show. When I connect through sql pro the tables never show up. I have tried for 3 nights.
I have installed the vagrant bindfs plugin.
Here is my Homestead.yaml
ip: 192.168.10.10
memory: 2048
cpus: 1
provider: virtualbox
authorize: ~/.ssh/id_rsa.pub
keys:
- ~/.ssh/id_rsa
folders:
-
map: /Applications/MAMP/htdocs/laravel/rhtest
to: /home/vagrant/Code
type: "nfs"
sites:
-
map: rhtest.app
to: /home/vagrant/Code/public
databases:
- homestead
name: rhtest
hostname: rhtest
ports:
- send: 63790
to: 6379
protocol: udp
my .env is just the normal.
I'm wondering if it is a permissions problem for the DB. Any suggestions would be great.
Level 67
And 33060 for the mysql port (default)
Level 53
As a side note, you should make permissions corrections for Vagrant so that sudo is not required. For that matter, node or composer should require sudo either. You are asking for trouble if you continue on that road. In case you never came across any, some nasty people write packages that seem worth trying but they are just waiting for someone to install the code with sudo privileges to do nasty things. It is really not that hard to correct the permissions and you only ned to do it once.
I use SequelPro with 127.0.0.1 and port 33060 for a standard connection to MariaDB or MySQL.
1 like
Please or to participate in this conversation.