Page 1 of 1

ERROR at Config, Step 3 re: MySQL DB

Posted: Sun Dec 27, 2020 10:09 am
by MMinieri
I'm sure it's something simple (Newbie here) but nothing I try resolves it. Doing a fresh install of OC3. The full error message (it's LONG), my step 3 config form, and screenshots of current DB and User are posted here [b]https://www.ceperianas.com/TECH_ISS ... e.jpg [/b] . Pretty annoying since I removed (via CPanel) the previous copy of OC to minimize have to fix my own errors. Any help will be appreciated. Thanks in advance.

Re: ERROR at Config, Step 3 re: MySQL DB

Posted: Sun Dec 27, 2020 11:32 am
by sw!tch
try localhost for hostname. Ensure your DB credentials are correct per your cpanel.

Re: ERROR at Config, Step 3 re: MySQL DB

Posted: Sun Dec 27, 2020 2:11 pm
by MMinieri
Thanks. Tried with LOCALHOST ... no joy. Can anyone confirm WHICH USERNAMES to insert in Part 1 and 2? I assume Part 1 is a user created when the DB was created. Part 2 says "for administration" ..... of WHAT? OC itself or the DB? Also, EMAIL is my ACTUAL email? The error massage starts with a reference to xxxx@(some IP address?).

Re: ERROR at Config, Step 3 re: MySQL DB

Posted: Sun Dec 27, 2020 2:36 pm
by sw!tch
On the installer.

Config Section 1 is your database setup.

Config Section 2 is your Opencart Store Administration panel setup.

Maybe watch the video in the documentation here - http://docs.opencart.com/en-gb/installation/

Re: ERROR at Config, Step 3 re: MySQL DB

Posted: Sun Dec 27, 2020 4:26 pm
by MMinieri
Thanks for the reply and link. That is the link I was following when I got hung up at STEP 3. I will keep at it.

Re: ERROR at Config, Step 3 re: MySQL DB

Posted: Sun Dec 27, 2020 5:21 pm
by pprmkr
Error message with wrong credentials for database access.
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'ceperianascom'@'localhost' (using password: YES) in /home4/riannace/public_html/ceperianas.com/system/library/db/mysqli.php on line 7Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home4/riannace/public_html/ceperianas.com/system/library/db/mysqli.php on line 10Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home4/riannace/public_html/ceperianas.com/system/library/db/mysqli.php on line 10Notice: Undefined variable: mysql in /home4/riannace/public_html/ceperianas.com/install/controller/install/step_3.php on line 280Notice: Trying to get property 'connect_error' of non-object in /home4/riannace/public_html/ceperianas.com/install/controller/install/step_3.php on line 280

Log in CPanel and find database settings. Server address ( hostname ), database user ( username ) and database name. When you cannot recall password, change it . And then enter that credentials in setup step 3.

Re: ERROR at Config, Step 3 re: MySQL DB

Posted: Mon Dec 28, 2020 8:09 am
by MMinieri
Thanks all. I missed some facts that were not clear in any of the OC docs I searched. Most importantly;

* DB name cannot have any UPPER CASE letters ..... such as oc vs OC
* The DB password in Part 1 is - apparently - something created by the HOST

Starting over again