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
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:
The name of the connection. This can be everything. It is up to you.
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.
The username or login name of the database user.
The password of that user.
You have to say to which database you want to connect. A host can manage multiple databases.
You can set a port if you do not use the standard port.
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.
Sequel Pro is a must have for all web developers on Mac OSX.