How to access old database - I installed new Prestashop

[cloak]

Hi

 

I installed Prestashop on my webhost under a sub-directory called online/

 

I configured the shop, added categories, products, images with no problems etc.

 

My database had the prefix qnt_

 

I then installed Prestashop to my root directory and when it asked me for my database info I filled it

in the mysql database info but I forgot to change the prefix.

 

Prestashop installed no problems on the webhost.

 

When I try to go to the url I get:

 

Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'FYgcEgOOvN22Gs1'@'boscustweb2405.eigbox.net' (using password: YES)

 

This user does have access to the database through mysqladmin panel.

 

I even created another user in mysqladmin, gave all the rights, and changed the settings.inc.php

file to reflect the new user and I still can't get in.

 

Any ideas?

 

Thanks

[vekia]

you mean that you installed prestashop once again in the same database with the same db prefix?

[cloak]

Prestashop was installed in the same database but with a different prefix.

 

When I enter the database I see the new tables with the prefix pt_

 

Then I scroll down and see the old tables with the prefix qnt_

 

Can I still use this database? Or at least remove the tables with the prefix pt_???

 

I can browse the old tables and see the old data is still there.

 

Thanks

[vekia]

you can use this databsae

and in settings file in /config/ directory you can change prefix information

so instead of new prefix, type there old one

[cloak]

Is this done in settings.inc.php?

 

Is there also any other files in the config folder that I have to edit?

 

I have edited this file with the server address, database name, username, and password that is shown in mysqladmin and I get

the following error:

 

Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'âFYgcEgOOvN22G'@'boscustweb2402.eigbox.net' (using password: YES)

 

I notice in the error message that this character â has been added to the username but I have not typed it in settings.inc.php

 

Thanks

[cloak]

I created a connection.php file that contains:

 

<?PHP

mysql_connect("cloaksolutionscom.dotstermysql.com", "username", "password") or die(mysql_error()) 

?> 

 

The screen is blank after running this file.

 

So it looks like the settings.inc.php is not working correctly.

 

I have in the settings.inc.php file:

 

The database, username, password, key have been changed below

 

<?php

define('_DB_SERVER_', 'cloaksolutionscom.dotstermysql.com');

define('_DB_NAME_', 'databasename');

define('_DB_USER_', ‘username’);

define('_DB_PASSWD_', 'password!');

define('_DB_PREFIX_', ‘pt_’);

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_', '447eeeru81HqXQCGtM5cf9SqMJJidCqRCsawfKAcHZfhsn1xb1ZaRFWN');

define('_COOKIE_IV_', '8P7JKJVY');

define('_PS_CREATION_DATE_', '2014-06-22');

define('_PS_VERSION_', '1.6.0.6');

define('_RIJNDAEL_KEY_', 'key alphanumeric here');

define('_RIJNDAEL_IV_', '6awNZZehXshxHGZlYlbHyA==');

 

Any ideas??

[El Patron]

Is this done in settings.inc.php?

 

Is there also any other files in the config folder that I have to edit?

 

I have edited this file with the server address, database name, username, and password that is shown in mysqladmin and I get

the following error:

 

Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'âFYgcEgOOvN22G'@'boscustweb2402.eigbox.net' (using password: YES)

 

I notice in the error message that this character â has been added to the username but I have not typed it in settings.inc.php

 

Thanks

 

yes  in settings,inc.php

define('_DB_PREFIX_', 'yourprefix_');

 

also the php code above would return a blank page because you are not outputting anything to the screen