How do I connect to a MySQL database using Sequel Pro?


Browse by products and services

  • Applies to: Grid
    • Difficulty: Easy
    • Time Needed: 10
    • Tools Required: Sequel Pro

Overview

The following article will show you how to setup Sequel Pro to make a secure connection to your MySQL Databases.

Requirements

Before you start, you'll need:

You may find you need to manually set the MySQL or SSH port numbers. On the Grid, we use the standard ports for MySQL and SSH.

MySQL: 3306
SSH: 22

Instructions

To setup Sequel Pro, we will use an SSH connection to ensure a secure connection to your MySQL database(s).

  1. Launch Sequel Pro.
  2. Choose SSH under the connection details, see Figure 1.

    1796_001
    Figure 1.

  3. Enter your information, see Figure 2.

    1796_002
    Figure 2.

    • Name: s000000.gridserver.com (Be sure to replace 000000 with your site number).
    • MySQL Host: internal-db.s000000.gridserver.com (Be sure to replace 000000 with your site number).
    • Username: db000000 (Be sure to replace (Be sure to replace 000000 with your site number).
    • Password: The password for your MySQL user.
    • Database: (optional) Leave blank to have access to all of your databases.
    • Port: 3306
    • SSH Host: s000000.gridserver.com (Be sure to replace 000000 with your site number).
    • SSH User: s000000.gridserver.com (Be sure to replace 000000 with your site number).
    • SSH Password:  Your ssh password.
    • SSH Port: 22
  4. Click on Add to Favorites, then double-click on the new bookmark to connect to your MySQL databases.
  5. Done.

See also