Connect Homestead's mySQL through Sequel Pro
Host: 127.0.0.1
Username: homestead
Pass: secret
Port: 33060
Sequel Pro can't connect to Vagrant (Puphpet) Ubuntu's mySQL
Problem: If you can't connect with VM's mySQL through Sequel Pro, then it might be becasue of the lack of password of default vagrant
user and on the other hand the id_rsa
key file is not working somehow.
Solution: Enter into that VM using auto ssh and then change the password of the user vagrant
by executing command passwd
. Set new password for vagrant
and use that password while connecting from Sequel Pro using SSH tunnel. SSH host would be VM's private IP address, user would be vagrant
, password be new one, port would be default 22
or blank.
MySQL's host would be 127.0.0.1
and user would be root
and default password 123
Known Hosts Issue Edit the file sudo vi ~/.ssh/known_hosts
and remove the line starts with the IP that was previously associated with an deleted VM may be.
Apache header info is not being received by PHP in Vagrant box
Solution: Set Env section for adding allowing Authorization
or other header info.
...
setenvif:
- 'Authorization "(.*)" HTTP_AUTHORIZATION=$1'
...