UPDATE: WAS MY ERROR
Ionos use a different db name to the host db name - info was in plain sight, but not clearly enough for me apparently
Having a problem during a fresh 3.0.3.7 install.
Set up folder/database etc on server, uploaded the upload folder contents, renamed config-dist & admin config-dist. Go to website and am greeted with the Opencart setup - all goes fine until I enter database details and then click continue.
Am then presented with an Error 1044 from ionos
Quick Google gives me this
In the IONOS web hosting packages, the use of the MySQL commands CREATE DATABASE %DatabaseName% and USE %DatabaseName% are blocked for you for administrative reasons. Imports of SQL files that contain these commands fail with error 1044 - Access denied. To import a database nevertheless, for example to change the MySQL version, follow the steps below.
Make a backup copy of the SQL file you want to import.
Open the SQL file with a text editor, such as Notepad++.
Search for strings that are CREATE DATABASE %Database name% or USE %Database name%. %DatabaseName% is a placeholder for the actual database name in your SQL file.
Delete these commands. Be careful not to inadvertently remove other statements.
Save your changes.
Anyone experienced this before?
Which file(s) will I need to edit to permit the Opencart installer to get past the database page.
Thanks
OpenCart doesn't use CREATE DATABASE. The issue must be something else. Check the database details you are entering are correct and the database user has the right permissions.
Last edited by ADD Creative on Sat May 29, 2021 5:39 am, edited 1 time in total.
Thanks for the reply.
I have tried deleting and reinstalling OC, have deleted and created new database still not much further forward.
Setting up a MySQL database with my hosting company gives you a single username for that database. I cant seem to find anywhere to add users, but have noticed that when I try to continue step 3 of OC install I get the following error which has a totally random user name.
Error: Access denied for user 'o2099975'@'%' to database '****del for security****'
Error No: 1044
Any thoughts/help really appreciated.
I have tried deleting and reinstalling OC, have deleted and created new database still not much further forward.
Setting up a MySQL database with my hosting company gives you a single username for that database. I cant seem to find anywhere to add users, but have noticed that when I try to continue step 3 of OC install I get the following error which has a totally random user name.
Error: Access denied for user 'o2099975'@'%' to database '****del for security****'
Error No: 1044
Any thoughts/help really appreciated.
Personally I would test the database connection with your own test PHP file like in the examples.
https://www.php.net/manual/en/mysqli.construct.php
https://www.php.net/manual/en/mysqli.construct.php
Glad you got it figured out and yea, for some reason, they use their own format.
Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhost.com
Active Member
Who is online
Users browsing this forum: No registered users and 177 guests