Sequel Pro

Sequel Pro is a MySQL database client for MacOSX. This program is free to use and has a really easy handling. If you combine it to PhpMySQL it runs faster and has a far better interface. For this client you need:

• Mac OSX 10.5 oder better
• MySQL Server 3, 4 or 5

Configuration

With Sequel Pro you can define multiple MySQL connections and save the login data. So you can connect with just one click. For a new connection you need:

• Name
  The name of the connection. This can be everything. It is up to you.
  
• Host
  This is the IP address or the domain name for your MySQL server. If you want to connect to local MySQL server (for example XAMPP) you can user ‚localhost‘ as host.
• User
  The username or login name of the database user.
• Password
  The password of that user.
• Database
  You have to say to which database you want to connect. A host can manage multiple databases.
• Port
  You can set a port if you do not use the standard port.

Handling

Working with Sequel Pro is quite easy. The user interface is simple and you can find all main functions without problems. The client has a view for all tables of the database and a content view for structure, relations, content, information and a SQL creator where you can type your own SQL syntax.

Conclusion

Sequel Pro is a must have for all web developers on Mac OSX.