Search

HostGator Web Hosting Help

MySQL Connection Strings

Summary

A connection string is a sequence of variables which will address the specific database and allow you to connect your code to your MySQL database.

If you do not have a database yet, the following article will provide you with the proper instructions: How to Create and Delete MySQL Databases and Users

Configuration

Once you have a database setup, create the database's tables either via phpMyAdmin, MySQL software or use an online PHP or Perl script.

Use the following configuration settings:

  • Version: MySQL 5
  • Username: cpUsername_dbUserName
  • Database Name: cpUsername_dbName
  • Password: The password for cpUsername_dbUsername
  • Hostaddress: localhost
  • Port: 3306

Connection String Examples

The connection string can be either of the two examples below (be sure to replace the variables in red with your actual information):

For Perl:

$dbh = DBI->connect("DBI:mysql:cpUsername_dbName:localhost","cpUsername_dbUsername","password");

For PHP:

$dbh=mysql_connect ("localhost", "cpUsername_dbUsername", "password")
or die ('I cannot connect to the database.');
mysql_select_db ("cpUsername_dbName");

For more information on how to work with phpMyAdmin. please visit: phpMyAdmin.net.



Was this resource helpful?
Helpful Unhelpful


Did this resolve your issue?
Solved Unsolved


Please add any other comments or suggestions about this content:





Recommended Help Content

Local MySQL Connection Blocked To Server
I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.HostGator.sg' is blocked because of many connection errors; unblock with 'mysqlad
Knowledgebase Article 269,427 views tags: blocked connection host localhost mysql

Connecting Scripts to MySQL Databases
This article will explain how to connect your scripts to your MySQL databases.
Knowledgebase Article 241,174 views tags: database mysql scripts

Managing Databases with Applications
This article will go over different application available for remote connection to your databases.
Knowledgebase Article 245,486 views tags: database mysql

Related Help Content

How to Create and Delete MySQL Databases and Users
This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
Knowledgebase Article 878,995 views tags: creation database mysql

IMAP Connection Limit
Can I make multiple IMAP connections to the same email address?
Knowledgebase Article 247,370 views tags: connections imap limit

How To Setup Remote Database Connection - Configure MySQL client Access
How do I remotely connect using a database management software?
Knowledgebase Article 1,186,152 views tags: connection database mysqlfront remote

MySQL Error Messages
This article will show a few MySQL errors along with explanations as to why they might be occurring.
Knowledgebase Article 135,454 views tags: errors mysql

Restore MySQL databases using the Site Backup & Restore tool
How to restore MySQL databases using the Site Backup & Restore tool
Knowledgebase Article 264,269 views tags: backup database mysql restore site

Change a MySQL Users Password
This article will explain how to change or reset the password for a MySQL user.
Knowledgebase Article 159,019 views tags: change mysql password reset user

Backup all MySQL databases using the Site Backup & Restore tool
How to backup all of your MySQL databases using the Site Backup & Restore tool
Knowledgebase Article 279,038 views tags: backup database mysql restore site

How To Rename Database Tables in PHPMyAdmin
This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 326,959 views tags: databases mysql phpmyadmin