We talking about Cloud
Web Hosting & Cloud Services
Celebrate the power and freedom of Open Source
with Open Source Cloud Servers starting at only £10/mo £5/mo.
A script contacting or querying the database for the information it stores is required for your MySQL database to function properly. To do so, you’ll need to use a configuration file to connect your script to the database.
If you’re not sure where your configuration file is, look through this list of scripts to locate it:
Configuration Settings
Database-driven software like WordPress, WHMCS, and Joomla will usually come with a default configuration file that you may change with the necessary information.
Examples of how this access information will appear are shown below:
Host Name = localhost (literally input localhost)
Database Name = cpanelUsername_databaseName
Database Username = cpanelUsername_databaseUsername
Database Password = whatever you selected
WordPress Example
| Username = joe1337 | Database Name = wrdp1 |
| Database-Username = wp1 | Database-User Password = eHTb7%Pxa9 |
// ** 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’);
While connecting to the database with your cPanel username and password is feasible, we DO NOT advocate it. Your databases will cease working if you change or reset your cPanel password before updating the configuration files.
Please read: Remote MySQL Connection to understand how to connect to the MySQL server.
- How to Connect to MySQL Remotely
Tips and Tricks for Moving Databases
-
The database name and login may change when you move databases to our servers. This change must be reflected in the code of your script. (In the MySQL part of cPanel, the database name and username are plainly shown.)
- On shared servers hosting, you can’t change the database username without also changing the cPanel username. This prevents database names and usernames from clashing with those of other users on the server.
MySQL User Has No Privileges
We’ve found an odd error with the 11.25 release in which adding an IP to the MySQL remote access list results in the accompanying MySQL user having no rights.
To add the appropriate privileges, follow these steps:
- Go to your MySQL Databases in cPanel.
- Select the user and the database from the drop-down menus to re-add the user to each database.
- Reassign the privileges.
- Click Add.
We’ve alerted cPanel about the problem in the hopes that it will be fixed in future versions.