HostMonster 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 66,542 views bookmark tags: connection databases mysql (updated 481 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 'host#.HostMonster.com' is blocked because of many connection errors; unblock with 'mysqlad (updated 23 days ago)
Knowledgebase Article 101,601 views tags: blocked connection host localhost mysql

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

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

Related Help Content

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

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

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

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

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

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

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

Optimizing MySQL: Queries and Indexes Article 2 of 4 Courtesy of: Ian Gilfillan Some knowledge of how indexes work allows you to use them more efficiently. Firstly, note that when you update a table w (updated 1359 days ago)
Knowledgebase Article 83,452 views tags: indexes mysql optimize optimizing queries query