MySQL Connection Strings
A connection string is a sequence of variables that 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.
Use the following configuration settings:
- Version: MySQL 5
- Username: cpUsername_dbUserName
- Database Name: cpUsername_dbName
- Password: The password for cpUsername_dbUsername
- Host address: localhost
- Port: 3306
For PHP Version 5.4
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):
$dbh = DBI->connect("DBI:mysql:cpUsername_dbName:localhost","cpUsername_dbUsername","password");
$dbh=mysql_connect ("localhost", "cpUsername_dbUsername", "password")
or die ('I cannot connect to the database.');
Take Note: If you're using PHP version 5.6 and above, replace the mysql_connect with mysqli_connect. For more information on how to work with phpMyAdmin. please visit phpMyAdmin.net.