How to connect to a MySQL database?

In order for the MySQL database to work, you will first need either to use a calling script or to query the database for the information it stores. To do this, you need to connect your script to the database using a configuration file.

What are my database configuration settings?

Platforms like WordPress, WHMCS, and Joomla usually have a default configuration file ready for you to edit with the appropriate information.

• Hostname = localhost
• Database name = cpanelUsername_databaseName
• Database user name = cpanelUsername_databaseUsername
• Database password = the password you associated with your username when creating it
  

In the example below, we will use the basic WordPress settings (wp-config.php file format).

• cPanel username = example-ex2
• Hostname = localhost
• Database name = testdbex2
• Database username = clientEx2
• Database password = 09Xm2Ltq%X-t

The code associated with our example:

// ** MySQL Settings ** //

/** The name of the database for WordPress */

define('DB_NAME', 'exemple-ex2_testdbex2');



/** MySQL database username */

define('DB_USER', 'exemple-ex2_clientEx2');



/** MySQL database password */

define('DB_PASSWORD', '09Xm2Ltq%X-t');



/** MySQL hostname */

define('DB_HOST', 'localhost');

Updated on: 22/03/2023