Installation step 3 wants the database connection details, but no matter what I've put there I keep getting the message:
"Error: Could not connect to the database please make sure the database server, username and password is correct!"
I have created an SQL database in MySQL in my CPanel. It is showing up, giving me the name of the database and user name. I have typed them in repeatedly. I even deleted one database and created a new one, wondering if there was some problem with the first one. All permissions are in place. The password is there and in place.
In "database host" I have tried "localhost." I have tried my domain name.
I've tried everything I can think of...and every combination in the different response boxes.
I must be missing something, and it's probably very simple and I'll feel like an idiot when you help me find it. But I am completely stumped.
Right now I am looking at:
*Database Host: localhost
*User: the name which appears in CPanel, in the "user" box
Password: the users password
*Database Name: the name which appears in CPanel, in the "database" box
Database Prefix: I just wrote in "oc" ...shortened form of the database name
And I am getting the message above.
I must be missing something...but I can't figure out what it is. Can you help me?
Thank you in advance for all efforts
After another 15-20 minutes working on it, I found the problem...and it was as small and foolish as I had supposed...a typing error in the password which I was repeating over and over again.
Problem is solved. Sorry to waste your time...though I suspect I'll be writing back about something else before too long, as we're trying to learn our way around the program.
Why is this step so simple, yet so many people struggle?
oh no, 4 hours no-one would accuse you of giving up easily.craigsplates wrote: now 4 hours on, 8th database and username, still cpanel, still wont connect...
http://forum.opencart.com/viewtopic.php ... 959#p97776 may help - it depends where you are stuck, and why.
I have tried so many time at the third step(Configuration) and I repeatedly make a new database in phpmyadmin but the result is still same:
Code: Select all
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
Im a student and i have to send this early so i hope that u can reply this as soon as u read
Reason: Added code tags.
Ensure both database are properly configured from your database host console and in your config.php and admin/config.php files.Access denied for user
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.
Programmer / Opencart Tester
Users browsing this forum: No registered users and 15 guests