Bluehost 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.

Knowledgebase Article 275,744 views bookmark
share
Share or save this via:
tags: connection databases mysql


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#.Bluehost.com' is blocked because of many connection errors; unblock with 'mysqlad

Connecting Scripts to MySQL Databases

This article will explain how to connect your scripts to your MySQL databases.

Managing Databases with Applications

This article will go over different application available for remote connection to your databases.

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.

IMAP Connection Limit

Can I make multiple IMAP connections to the same email address?

How To Setup Remote Database Connection - Configure MySQL client Access

How do I remotely connect using a database management software?

MySQL Error Messages

This article will show a few MySQL errors along with explanations as to why they might be occurring.

Restore MySQL databases using the Site Backup & Restore tool

How to restore MySQL databases using the Site Backup & Restore tool

Change a MySQL Users Password

This article will explain how to change or reset the password for a MySQL 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

How To Rename Database Tables in PHPMyAdmin

This article will show you how to rename a database table in phpMyAdmin.