This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here

Skip to main content

Just Host 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,651 views bookmark tags: connection databases mysql


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#.Justhost.com' is blocked because of many connection errors; unblock with 'mysqlad
Knowledgebase Article 265,353 views tags: blocked connection host localhost mysql

This article will explain how to connect your scripts to your MySQL databases.
Knowledgebase Article 237,066 views tags: database mysql scripts

This article will go over different application available for remote connection to your databases.
Knowledgebase Article 241,125 views tags: database mysql

Related Help Content

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
Knowledgebase Article 873,577 views tags: creation database mysql

Can I make multiple IMAP connections to the same email address?
Knowledgebase Article 244,048 views tags: connections imap limit

How do I remotely connect using a database management software?
Knowledgebase Article 1,178,136 views tags: connection database mysqlfront remote

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

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

This article will explain how to change or reset the password for a MySQL user.
Knowledgebase Article 154,910 views tags: change mysql password reset user

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

This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 322,347 views tags: databases mysql phpmyadmin

** Google ad credits are only available to customers in the United States, Canada, and the United Kingdom at this time.

¹ VAT (Value Added Tax) is not included in our advertised price and will be charged separately and itemized on invoices and billing information. Standard VAT rates based on EU Member State regulations may apply. Learn more.