How to connect to mysql at hostgator

Written by mike heldar
  • Share
  • Tweet
  • Share
  • Email

Many applications you store on your Hostgator Web hosting provider account require a user name, password and hostname. Remote applications, such as the MySQL query browser also need the server's IP address and port to properly connect to a MySQL database. These databases are critical parts of Web application operation because they are used to update, delete, add and read new information in real-time. Most programs have a configuration file where these connection settings are stored and you must enter your database's security information before they can make use of your account.

Skill level:
Moderately Easy


  1. 1

    Open the MySQL connection configuration file or dialogue in your program. There is no standard location for this, so consult your program's manual, readme or install instructions file for further directions.

  2. 2

    Locate the "Host," "Hostname" or "Database IP" field. Enter "localhost" if this is a script or program you are uploading to your host. Enter your Hostgator server IP address if connecting from a query browser application. This information was sent to you along with your FTP information in the welcome e-mail.

  3. 3

    Enter "cpanelusername_databasename" for the "Database name" field. For example, if your database is named "AccountRecords" and your CPanel username is "muffin 342," your database name is "muffin342_AccountRecords."

  4. 4

    Enter your cPanel and database username for the "Database username" field. For example, "muffin342_Accounting" if your MySQL username is "Accounting."

  5. 5

    Supply the password to your database in the "Database Password" field.

  6. 6

    Enter the port "3306" using either Transmission Control Protocol (TCP) or User Datagram Protocol (UDP) for the connection protocol.

Tips and warnings

  • Unlike many hosts, Hostgator allows you to remotely connect directly to your database. If your connection is refused, you'll have to e-mail "" with your IP address to allow direct access to your database.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.