Jump to content
veijari

Connecting db to a cloned instance

Recommended Posts

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

Share this post


Link to post
Share on other sites

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)

 

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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!

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More