How do I Sequel Pro with PuPHPet?

Question

I have just set up a virtual machine using Vagrant and Puphpet. I know I have MySQL because I can mysql in the command line. I just did a basic install.

I don't know how to set up my sequel pro to get access though. I am using the "Standard" option on the Sequel Pro application (the others are "Socket" and "SSH"). Is that the right one to use? The values I enter are;

Name: awesome Host: 192.168.56.101 Username: mlovely Password: mlovely Port: 9000

Here is my part of my config.yaml file that relates to mysql

mysql:
  install: '1'
  override_options: {  }
  root_password: root
  adminer: 0
  databases:
    0x04jJcIakVr:
        grant:
            - ALL
        name: dbname
        host: localhost
        user: mlovely
        password: mlovely
        sql_file: ''

Not sure where to look or what else to try now.. The error I get on sequel pro is an "Unable to connect or the request timed out" type.

Answer 1

I put the information on puphpet.com - maybe you missed it

Answer 2

You can connect using the SSH tab (username/password are 'vagrant') in Sequel Pro. The database input fields have to match the settings in the config.yaml.

If you cannot connect using vagrant/vagrant ssh into the vm type passwd and enter vagrant twice. You've now set the password for the vagrant user to vagrant. This does not affect the ssh functionality in vagrant, because vagrant uses ssh-keys.