IXWebhosting Database Connection !Fix!

I was installing WP on IXWebhosting and I kept getting:

Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at mysql4.ixwebhosting.com. This could mean your host’s database server is down.

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?

If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

I kept checking what I was entering into the fields and everything was correct. I added permissions, Usernames, changed passwords, used the ip instead of the hostname.

I then started opening up files and looking at it and everything looked good in wp-config.php

But then I looked closer and noticed a very big problem. When IXWebhosting creates db names and db usernames they format it like this “IXUSERNAME_DATABASENAME” and “IXUSERNAME_DBUSERNAME”. Which is what I entered but it wasnt what was in the config file. Word Press seems to strip the first part of the username from what you post in the form so “IXUSERNAME_DBUSERNAME” becomes “DBUSERNAME”

Which fails when you try to install so to make it work you have to open the config file and update:

/** MySQL database username */
define(‘DB_USER’, ‘DBUSERNAME’);

TO

/** MySQL database username */
define(‘DB_USER’, ‘IXUSERNAME_DBUSERNAME’);

This took me hours to figure out this little error. I knew I was typing it correctly in the form fields. Most of the text here things I searched for, so hopefully this gets indexed fast.

This needs to be submitted as a bug to WP.

TL DR Version WordPress removes the first part of IXWebHosting Database Usernames when using the quick setup form. Modify wp-config.php to have the correct IXWebhosting username.