Use Sequel Pro for Mac OS X to manage MySQL databases

This article will discuss installing Sequel Pro for Mac OS X.  It is an intuitive and easy to use program that will allow you to manage MySQL databases, run queries, and update any information in a MySQL database table.

  1. On your Mac download Sequel Pro and install the application.
  2. Open Sequel Pro
  3. Click the Standard tab
  4. Enter in a database host, database username, database password and database name
  5. Click Connect.
  6. Once connected the database tables will be listed in the left column with the selected table contents in the right panel
  7. To edit click on the specific table content on the right hand panel
  8. To enter a query, click Query at the top
  9. Select the table name from the left hand column
  10. Enter your query in the text field
  11. Click Run Current
  12. To export a table, navigate to the File menu and choose Export. From there you can export a single table or the entire database and save it locally to your Mac