123Reg, MySQL, wp-config.php

I’m trying to correctly setup a MySQL database and edit wp-config.php to install WP on my 123Reg domain.
None of the many articles or videos I’ve found are solving my problem.

When I entre my website’s URL into a browser I get the following message:
Error establishing a database connection

This is what I’ve done so far:
(Some names and numbers have been changed in case it makes any difference to security.)

In the MySQL page on 123Reg I’ve created a new user.
Name : WPuser
Password : ThisIsNotMyRealPW

This seemed to create a database with the following details:
Server : 35.21.239.28 (internal: 11.17.26.5)
username : WPuse-b7g-w-056480 (This confuses me because the Username is not WPuser.)

Moving over to the wp-config.php file, I know I need to edit the following information:
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘WPuser’);
/** MySQL database username */
define(‘DB_USER’, ‘WPuser’);
/** MySQL database password */
define(‘DB_PASSWORD’, ‘ThisIsNotMyRealPW’);
/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);

I’ve tried various combinations of DB_NAME and DB_USER; both WPuser and WPuse-b7g-w-056480
Looking at 123Reg’s support pages, I’ve found som informaion that DB_HOST should perhaps be cust-mysql-123-02 or cust-mysql-123-03 or cust-mysql-123-04 or cust-mysql-123-05 or atlas-sql-07, but I think localhost is right.

Nothing I’ve tried so far works.
Can anyone tell me what I’m getting wrong please?

• This topic was modified 9 years, 7 months ago by eyeghoti.