HostMonster Web Hosting Help

MySQL Connection Strings


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


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:

Knowledgebase Article 74,063 views bookmark tags: connection databases mysql (updated 619 days ago)

Was this resource helpful?

Did this resolve your issue?

Please add any other comments or suggestions about this content:

Recommended Help Content

I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host '' is blocked because of many connection errors; unblock with 'mysqlad (updated 161 days ago)
Knowledgebase Article 107,120 views tags: blocked connection host localhost mysql

This article will explain how to connect your scripts to your MySQL databases. (updated 987 days ago)
Knowledgebase Article 33,989 views tags: database mysql scripts

Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1890 days ago)
Knowledgebase Article 65,645 views tags: connection ip mysql putty ssh whitelist

Related Help Content

This article will go over different application available for remote connection to your databases. (updated 990 days ago)
Knowledgebase Article 51,549 views tags: database mysql

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 51 days ago)
Knowledgebase Article 485,852 views tags: creation database mysql

This article will show a few MySQL errors along with explanations as to why they might be occurring. (updated 984 days ago)
Knowledgebase Article 16,471 views tags: errors mysql

How to backup all of your MySQL databases using the Site Backup & Restore tool (updated 1522 days ago)
Knowledgebase Article 62,312 views tags: backup database mysql restore site

How to restore MySQL databases using the Site Backup & Restore tool (updated 1388 days ago)
Knowledgebase Article 49,081 views tags: backup database mysql restore site

This article will explain how to change or reset the password for a MySQL user. (updated 107 days ago)
Knowledgebase Article 2,381 views tags: change mysql password reset user

How to restore MySQL databases using the Site Backup & Restore tool (updated 1161 days ago)
Knowledgebase Article 61,135 views tags: backup database mysql restore site

This article will instruct you how to import a database from the command line (SSH). (updated 158 days ago)
Knowledgebase Article 429,734 views tags: database mysql ssh