Importing databases allows us to generate structures from other websites through an editable file. This process, which at first glance does not require special dedication, can drive us crazy and exhaust our patience in record time, so the use of guides or orientations is especially appreciated.
If you have ever encountered the dreaded ' ACCESS DENIED CREATE DATABASE db_name ' (which I fear) and you want to find a solution, you have come to the right place. At Línea Gráfica we have set ourselves the rigorous mission of making your life a little easier with a series of simple tutorials that will get you out of more than one tight spot.
For those who still don't know what causes such an error, it should be noted that the main and only reason is the lack of privileges of your MySQL user to create databases. Complicated to understand? Let's start there.Creating a database via cPanel
The first step is to make sure that there is a database on the MySQL server that allows us to import the data. To do this, we will go to the cPanel control panel, look for the "Databases" option and click on "MySQL Databases". We will create a new user and give it all the privileges to be able to carry out the installation.
Modify the file we are going to import
Next, using a text editor, we will delete the line “ CREATE DATABASE + the name of the database ” from the .sql file that we are going to upload. This simple modification will allow us to import the database into cPanel.Any questions to resolve?
Take advantage of the comments box to detail your experience. At Línea Gráfica we are experts in digital marketing and PrestaShop Platinum Partners, so if after the tutorial you need help importing databases, just get in touch with us. Our technicians work so that you can get the most out of your online business from all profiles.
