⚙️ Connect Database-Driven Scripts to Your MySQL Database
Database-driven systems like WordPress, WHMCS, and Joomla use a standard configuration file where you enter your database details. Below you’ll find an example of how to set this up.
📝 Your Database Details
Hostname:
127.0.0.1orlocalhostDatabase Name: Created in cPanel → MySQL Databases
Database User: Created in cPanel → MySQL Databases
Database Password: The password you chose when creating the user
You can find your MySQL users and password using the following guide.
📝 WordPress Example
Here’s how a WordPress configuration might look:
Your details:
Username:
joe1337Database Name:
wrdp1Database User:
wp1Password:
eHTb7%Pxa9
In wp-config.php:
// ** MySQL Settings ** // /** The name of the database for WordPress */ define('DB_NAME', 'joe1337_wrdp1'); /** MySQL database username */ define('DB_USER', 'joe1337_wp1'); /** MySQL database password */ define('DB_PASSWORD', 'eHTb7%Pxa9'); /** MySQL hostname */ define('DB_HOST', 'localhost');
⚠️ Important!
While it is technically possible to connect using your cPanel username and password, we do not recommend it. Each time you change or reset your cPanel password, your databases will stop working until the configuration files are updated.
✅ Done!
Now you know how to connect your scripts, such as WordPress, to your MySQL database via the configuration file.