Post by AditiAnand » Sat Apr 03, 2021 3:02 am

I am using Opencart version 3.0.3.7 for website development. Although I am able to make a successful connection using PuTTY from my application host, I am getting the below DB connectivity issue on Step 3 of Opencart installation.

Warning: mysqli::__construct(): (HY000/1045): Access denied for user '<database username>'@'<application server host name>' (using password: YES) in opencart/system/library/db/mysqli.php on line 7

Could anyone suggest to me something on this issue?

Newbie

Posts

Joined
Tue Mar 16, 2021 3:05 am

Post by xxvirusxx » Sat Apr 03, 2021 3:49 pm

Yes.
Wrong informations: like password, username, missing all permission for username...

My converted modules | Buy me a beer | Opencart upgrade service


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by AditiAnand » Tue Apr 06, 2021 3:58 am

With the same credentials like username, password, and host, etc., I am able to connect to the database from the MySQL client installed on the host. Therefore, credentials should not be the concern. Also, if I check the grants, it's been set using wildcard %.

Is there anything else that can be a concern or I should try doing?

Newbie

Posts

Joined
Tue Mar 16, 2021 3:05 am

Post by straightlight » Tue Apr 06, 2021 4:52 am

AditiAnand wrote:
Tue Apr 06, 2021 3:58 am
With the same credentials like username, password, and host, etc., I am able to connect to the database from the MySQL client installed on the host. Therefore, credentials should not be the concern. Also, if I check the grants, it's been set using wildcard %.

Is there anything else that can be a concern or I should try doing?
In this case, the error credentials message should neither be ignored.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by paulfeakins » Tue Apr 06, 2021 6:28 pm

AditiAnand wrote:
Tue Apr 06, 2021 3:58 am
With the same credentials like username, password, and host, etc., I am able to connect to the database from the MySQL client installed on the host. Therefore, credentials should not be the concern. Also, if I check the grants, it's been set using wildcard %.

Is there anything else that can be a concern or I should try doing?
Logins must be wrong, whatever you say.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by ADD Creative » Tue Apr 06, 2021 7:21 pm

AditiAnand wrote:
Tue Apr 06, 2021 3:58 am
With the same credentials like username, password, and host, etc., I am able to connect to the database from the MySQL client installed on the host. Therefore, credentials should not be the concern. Also, if I check the grants, it's been set using wildcard %.

Is there anything else that can be a concern or I should try doing?
Any special characters or leading or trailing spaces in any of the login credentials?

www.add-creative.co.uk


Active Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by AditiAnand » Tue Apr 06, 2021 9:32 pm

I have an underscore in the database name. However, I tried with the one having no underscore as well. That also did not help.

Newbie

Posts

Joined
Tue Mar 16, 2021 3:05 am

Post by straightlight » Tue Apr 06, 2021 10:11 pm

AditiAnand wrote:
Tue Apr 06, 2021 9:32 pm
I have an underscore in the database name. However, I tried with the one having no underscore as well. That also did not help.
Simply compare the database information with the ones from your host console. If you don't know how to proceed, either look on Google, Youtube, contact your host or create a new service request in the Commercial Support section of the forum to pull your information.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 20 guests