Unable to connect the database with new host.

[wmorris]

I have just moved my store to a new host I am trying reconfigure my configure.php file.

Here is my database information:

// define our database connection

define('DB_TYPE', 'mysql');

define('DB_PREFIX', '');

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'hkeaton_giftshop2');

define('DB_SERVER_PASSWORD', 'XXXXXXX');

define('DB_DATABASE', 'hkeaton_giftshop2');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'db');

// for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage


I think I am missing a DB Prefix or something.

[stevesh]

If the name of your database is 'giftshop2' and your hosting account user name is 'hkeaton", and you created a DB user named 'giftshop2' that should be right. Otherwise, I'd guess you have the user name wrong.

Usually, hosts prepend the CPanel user name to the DB name, and to any DB user you set up in the DB section.