Post by mememe » Tue Mar 14, 2017 6:22 am

Seems this has been asked many times but with no definitive answer or one that makes sense to me!, I hope someone can help, desperately need my site live!

http://www.worldwondersgardens.co.uk/

Getting this error from uploading my site to my host from my computer, site works fine on my computer until its uploaded with the sql database then get the error message

Warning: mysqli::__construct(): (28000/1045): Access denied for user 'admin'@'localhost' (using password: YES)

Permissions for the 2 config files are 444 (tried 744 as some pages suggest also) and have the updated paths, which as far as im aware are correct.

Please help!!!
Thanks
Last edited by mememe on Sun Apr 02, 2017 6:12 am, edited 1 time in total.

Newbie

Posts

Joined
Fri Apr 01, 2016 3:44 am

Post by victorj » Wed Mar 15, 2017 6:03 am

Your opencart install has no access to database.
possible errors:
1 config files donat have correct database information.
2 database not configured properly
2 database user does not have correct permissions to access and or edit database.

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Eigen productie en snelle levering.
https://123-deurrubbers.com


User avatar
Newbie

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by mememe » Wed Mar 15, 2017 8:15 am

Ok, following this section...
After creating new MySQL database you have to assign a user to it. You create a new user in the MySQL® Databases section of cPanel and make sure that it has the same name and password as those you used in your project (the one you downloaded from subfolder in step 2). If you create a new user with a new database password chances are that you’ll get an error “Access denied for user…” at the end of the process.
which is the error im getting.

in thie original config files on my offline (working) site, this is set as
define('DB_DRIVER', 'mysqli');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', 'root');

in the uploaded site these username and password in the config files need to be changed to the ones set for the newly setup database user?
In the original offline site, I have a saved root username and password different from 'root', pretty sure this was setup when the original OC was setup the first time.

Doesnt work leaving the uploaded config files user and pass to root either.

What am i missing?

Its taken nearly a year to finish my site and populate the database, this is falling flat on its face at the finish line :(
Im not a coder or web designer, I just dont understand this bit...

Newbie

Posts

Joined
Fri Apr 01, 2016 3:44 am

Post by cyclops12 » Wed Mar 22, 2017 2:34 am

When you set up your new database on your server you will have setup a username and password
This should be the details you need to update the config files in your site which you have moved/copied to server

Newbie

Posts

Joined
Sun Sep 27, 2015 1:10 am

Post by mememe » Sun Apr 02, 2017 6:11 am

Solved, and it was a stupid one :(

For the record if anyone else is having the same issue, there were no other pages mentioning this as a fix....

The USERNAME in the config file, needed the full name supplied by the database, although I had the username and password correct, the database admin page for setting up the user for the database added the host name
' host_username '.

I tried EVERY way possible to change passowrds, usernames etc, but hadnt realised I needed the "hostname underscore" bit before the username.

So dumb, so simple to fix, and so frustrating :(

Newbie

Posts

Joined
Fri Apr 01, 2016 3:44 am
Who is online

Users browsing this forum: No registered users and 17 guests