#sequel pro

Connection is made through SSH. Default SSH username is vagrant and private key can be found in puphpet/files/dot/ssh/id_rsa.

There are many ways to install and run MySQL on your local computer, believe me, I’ve tried a lot of different ways. The easiest way I found is using [the scripts from the fine folks at Mac MiniVaults] (http://www.macminivault.com/mysql-mavericks/). With…

This might be old news to most of you, but I just discovered Sequel Pro. I've been using Navicat for the last 7 years to work with local + web databases. It's always done the job, but it was missing some key features I needed, and it crashed frequently.

In OS X Server we could never get Sequel Pro connected to MySQL. We were not sure if this was a common issue for most users, or just a problem we were having. 

Attempts at "Standard" or "Socket" connection methods were denied, but it turns out "SSH" is the way to go. We wanted to post this in case any other OS X Server users were having the same problem, and the developer site offers no tips for OS X Server.

We are running OS X Server 10.8 Mountain Lion on a MacMini, but this should also resolve the same problem for 10.6-10.7 setups.

1. Make sure that MySQL is running on your server, which there is now a Preference Pane for: http://dev.mysql.com/doc/mysql-macosx-excerpt/5.6/en/macosx-installation-prefpane.html

2. Remote connections to your server must also be enabled.

In OS X Server 10.8, check for this setting under Systems Prefs > Sharing, and verify "Remote Login" is checked. (In 10.6 Snow Leopard SSH might have been a setting in Server.app side tray/services list? Sorry, we cannot remember...)

3. Now create a new connection Favorite in Sequel Pro.

Please note the  upper password is for MySQL, the lower SSH password is for your Mac user account. These are the settings we used for our installation:

Beauty

To thank the Sequel Pro team for their help with Coda 2, we promised to make them an icon.

Database icons are boring — always a stack of metal cylinders. Since Sequel Pro makes editing databases more delicious, we thought the database could be more delicious as well!

Amplify’d from thenextweb.com

0 Monday April 25, 2011, Joel Falconer

11 Helpful Free OS X Utilities for Web Designers

Paparazzi!

Paparazzi! is a tool that makes screenshots of webpages. You can set the size of the browser window, making it the perfect tool for grabbing shots for comparison of sites that use media queries.

Sequel Pro

Sequel Pro is a free alternative to Querious, the MySQL database management app. If you don’t want to set up a script like phpMyAdmin, Sequel is a great option.

Xee

Xee is a lightweight image viewer and browser that can replace Preview to give you more power and speed without the accompanying bloat that would mean you may as well fire up Photoshop. If you want to view hundreds of image files and make simple changes such as rotating and cropping, this is your app.

Colorate

Colorate is a light color scheming app that assists you in creating harmonized color palettes. You can generate and customize palettes from a single base color or an image, and save them as standard .clr files.

Simple CSS

Simple CSS is a visual CSS authoring tool. Most of us prefer to write our CSS manually in our editor of choice, but for some a more visual application is preferable. Simple CSS might not have an interface up to the standards of the popular CSSEdit, but it is free.

Alkaline

Alkaline is a tool for checking your designs in Windows browsers without firing up Boot Camp. The paid plans, which give you access to 8 browsers for testing, are pretty expensive, but according to the company you can test Internet Explorer 7 and Firefox 2 for free. Since most designers have recently stopped testing for IE6 this may be enough for you.

Dashalytics

Dashalytics is a widget that brings your Google Analytics data to the dashboard. Handy for quick checks on how your latest sites and designs are doing.

SvnX

SvnX is a GUI for Subversion that allows you to browse your repositories and working copies and work with them. If you’re a Subversion user who happens to be command line-averse, check out this app.

GitX

GitX is the same sort of deal as SvnX, but for Git, allowing you to explore your trees and commit from the GUI. Another app for the command line-averse.

Though in all seriousness, anyone serious about web design and development should get used to the Terminal.

ImageOptim

ImageOptim is a fantastic image optimization tool, one that I use all the time. Even when you’re saving for the web through your favorite major software package such as Photoshop, ImageOptim usually manages to reduce the size of your images by a whole lot more without compromising the image quality. If you download one tool from this list, ImageOptim is that tool.

Structurer

Structurer from Nettuts+ is a super simple but very useful tool for creating file and folder structures for new projects. Where it gets really useful is in its ability to grab the latest version of a framework or web app you enjoy working with — be it as simple as HTML5 Boilerplate or as complex as WordPress — and set it up in your project’s new folder, saving a whole lot of time going and manually downloading the files, uncompressing them and moving them to your folder. We’ve covered Structurer before, but no designer utility list would be complete without it.

Read more at thenextweb.com