Alun Rowe

ramblings about cars, tech, web development and more. BOTB Winner in 2010

Category: codeigniter

Connect SequelPro to Homestead Vagrant Mysql database

Although you can run multiple apps per vagrant box I’ve always been happier running Homestead in the Per Project mode.  It keeps things neat and tidy for me.  I’ve also found with more complex setups that Laravel Valet doesn’t always work as intended.

Using the default passwords the step as are as below.  If you start changing your defaults this may not work for you…

Ok, first step is to open SequelPro and create a new connection by clicking the small plus sign in the bottom left.

Add a connection to Sequel Pro

Next up click the SSH button in the connection window.

Choose SSH connection type in SequelPro

Now simply fill in the following details:

 

MySQL Host
127.0.0.1
Username
homestead
Password
secret
Database
homestead
Port
Leave empty (3306 as default)
SSH Host
192.168.10.10 (Or whatever you set yours too in your Homestead.yaml file)
SSH User
vagrant
SSH Password
secret
SSH Port
Leave empty
Connect using SSL checkbox
Leave empty

Now click Test Connection.

You will be asked if you want to trust the SSH server.  Choose Yes and you are good to go!

Codeigniter Beginners Tutorial Article

Over the Xmas break I was lucky enough to be asked to write an article for the “12 Devs Of Xmas”:http://www.12devsofxmas.co.uk/ website. Despite my advancing years this was the first time I’d been asked to write about web development in a technical manner so it was a bit of a learning curve for me.

The article is a very simple introduction to CodeIgniter but will hopefully get people far enough into the framework to start playing for themselves. Enjoy!

“Get to grips with CodeIgniter”:http://www.12devsofxmas.co.uk/2011/12/codeigniter/

Hopefullly it has been useful to many of you, and if not then let me know how I can improve for the future as I intend to keep writing now as I thoroughly enjoyed the experience.

Powered by WordPress & Theme by Anders Norén