SQL Error -SQLSTATE[42000] [1044] Access denied

[hardcorecoder]

Hi -

 

I moved prestashop from MAMP to my hosting server(Hostgator). Created new database in MySQL and tables were imported over from MAMP. Database shows no errors all tables and columns are there.

 

I'm trying to login to my admin but I get an Error :

 

Fatal error: Uncaught Link to database cannot be established: SQLSTATE[42000] [1044] Access denied for user 'name'@'localhost' to database ' name_databasename' thrown in /home/name/public_html/domain.com/classes/db/DbPDO.php on line 58

 

I have the correct user info in my settings.inc.php

 

<?php

define('_DB_SERVER_', 'localhost');

define('_DB_NAME_', ' name_databasename'); // I use my database name for my database

define('_DB_USER_', 'name'); // i use my database user name from hostgator

define('_DB_PASSWD_', 'password'); // i use my database login password from hostgator

define('_DB_PREFIX_', 'ps_');

define('_MYSQL_ENGINE_', 'InnoDB');

define('_PS_CACHING_SYSTEM_', 'CacheMemcache');

define('_PS_CACHE_ENABLED_', '0');

define('_MEDIA_SERVER_1_', '');

define('_MEDIA_SERVER_2_', '');

define('_MEDIA_SERVER_3_', '');

define('_COOKIE_KEY_', 'aAjxIxkZGSVtyR02kxOCAuDMPS1gPTm7R8QdLIWFrtb9nLgY138y5xDh');

define('_COOKIE_IV_', 'WnPQm0cA');

define('_PS_CREATION_DATE_', '2012-11-02');

define('_PS_VERSION_', '1.5.2.0');

define('_RIJNDAEL_KEY_', '8PoCGFGbxEnyZW3tm9xpyNEnT3xwhcDn');

define('_RIJNDAEL_IV_', 'RzH8uE3HRo0pqZsoczUdJQ==');

 

If you can point me in the right direction to fix this error that would be great.

 

Thanks,

 

Ray

Edited November 6, 2012 by hardcorecoder (see edit history)

[Carolina Custom Designs]

It sounds like you did not assign your DB user to your HostGator DB?

 

Marty Shue

[hardcorecoder]

Thanks Marty for the reply. I figured it out as it was a typo.

[Carolina Custom Designs]

Typos can be hard to find at times. Glad to hear you figured it out.

 

Marty Shue