Connection to the MySQL Database

Working MySQL database by purpose, it needs a script, which will call or query the database for necessary stored information. In this case you should connect the script in the database by a configuration file. If you don’t know where this file is located, please look at lists with different scripts to find it.

Settings of the Configuration

Scripts like Wordpress, WHMCS and Joomla are examples for database driven scripts and they usually have a default configuration file, which is ready for edit. Here is anexample, showing how will look like access information:

Host Name = localhost (literally input localhost)                            
Database Name = cpanelUsername_databaseName                  
Database Username = cpanelUsername_databaseUsername    
Database Password = whatever you selected                              


WordPress Example

// ** MySQL Settings ** //
/** The name of the database for WordPress */
define('DB_NAME', 'mike1337_wrdp1');

/** MySQL database username */
define('DB_USER', 'mike1337_wp1');

/** MySQL database password */
define('DB_PASSWORD', 'eHTb7%Pxa9');

/** MySQL hostname */
define('DB_HOST', 'localhost');

We do not recommendconnection to the database by your cPanel username and password.

Some tips how to move Databases

• If you move databases from servers, its name and username could change. Don’t forget to update this change in your script code. (You will find the database name and username in cPanel, then the MySQL).
  
• Please note: If you use shared servers, you can change the database username only if the new name contains the cPanel username in it. This is due to avoiding username conflicts with others on the server.