Upgrading - Access Denied

[Guest paulabakerparkin]

Hello,

I'm currently upgrading my store, but when running the upgrade script I come up with this:

MySQL Error Occured

1045: Access denied for user 'zrfthpz_ccrt1'@'localhost' (using password: YES)

How do I resolve this problem?

Paula

[Guest EverythingWeb]

The upgrade script uses the database settings (username, password, host etc) from the config of the store itself.

Make sure you haven't overwritten the global.inc.php with the upgrade and that your database user has permission to create tables (more likely)

Hope this helps.

[Guest paulabakerparkin]

Sure did, I had two different passwords!

Thanks

Paula

[Al Brookbanks]

Hi Paula,

This is because the user for mysql probably doesn't have table create privilidges.

You need to upgrade the users permissions. This can be done in phpmyadmin I think.

If not try this command in phpmyadmin.

Substitute xxx_ with your tables prefix if you have one.

CREATE TABLE `xxx_CubeCart_cats_lang` (

  `id` int(11) NOT NULL auto_increment,

  `cat_master_id` int(11) NOT NULL default '0',

  `cat_lang` varchar(20) NOT NULL default '',

  `cat_name` varchar(255) NOT NULL default '',

  KEY `id` (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=1;