Connecting db to a cloned instance

[veijari]

Hello. I'm completely new to prestashop. We have cloned manually a working prestashop instance to our dev server.

Now I have changed the credentials to match ours in confg/settings.inc.php.

Our prestashop version is 1.6.4.

Still when I try to import the sql on adminer it says "Error in query (1044): Access denied for user 'x'@'%' to database 'x'" (x:s being real user and database)

What am I missing here? Am I suppose to make a clean prestashop install because of all the cookies etc to make our developing instance work?

 

Thanks for the help in advance

[El Patron]

do not connect your cloned shop to production mysql db.

rather create a new mysql db/db use/db pwd

export your current prod mysql and import into you new

update your clone config to point to new mysql

in admin, seo&urls, update the domain and ssl domain with domain name (do not prefix with http(s)

 

[veijari]

8 hours ago, El Patron said:

do not connect your cloned shop to production mysql db.

rather create a new mysql db/db use/db pwd

export your current prod mysql and import into you new

update your clone config to point to new mysql

in admin, seo&urls, update the domain and ssl domain with domain name (do not prefix with http(s)

 

Hi, I'm not connecting it to production mysql, I'm trying to create a new developer database for it. I can't import the database because of errors and therefore I cannot access the admin section.

What should I do?

[El Patron]

you should then contact your hosting provider or hire an inhouse webmaster, I don't know why you are getting that error, we don't see that when we import mysql db's.

[veijari]

14 hours ago, El Patron said:

you should then contact your hosting provider or hire an inhouse webmaster, I don't know why you are getting that error, we don't see that when we import mysql db's.

Hi, I realized my mistake, the sql file was trying to make a new database. I commented it out and it worked. Thanks for the time anyway!