'SQLSTATE[HY000] [1044] Access denied for user 'youruser'@'10.%' to database 'yourdb''
It happens for either PDO or mysqli.
<b>Warning</b>: mysqli::__construct(): (HY000/1044): Access denied for user 'youruser'@'10.%' to database 'yourdb' in <b>/hermes/bosnacweb05/bosnacweb05ax/b670/dom.crmlehn83892/public_html/shop/system/library/db/mysqli.php</b> on line <b>7</b><b>Warning</b>: DB\MySQLi::__construct(): Couldn't fetch mysqli in <b>/hermes/bosnacweb05/bosnacweb05ax/b670/dom.crmlehn83892/public_html/shop/system/library/db/mysqli.php</b> on line <b>10</b><b>Warning</b>: DB\MySQLi::__construct(): Couldn't fetch mysqli in <b>/hermes/bosnacweb05/bosnacweb05ax/b670/dom.crmlehn83892/public_html/shop/system/library/db/mysqli.php</b> on line <b>10</b><b>Notice</b>: Undefined variable: mysql in <b>/hermes/bosnacweb05/bosnacweb05ax/b670/dom.crmlehn83892/public_html/shop/install/controller/install/step_3.php</b> on line <b>280</b><b>Notice</b>: Trying to get property 'connect_error' of non-object in <b>/hermes/bosnacweb05/bosnacweb05ax/b670/dom.crmlehn83892/public_html/shop/install/controller/install/step_3.php</b> on line <b>280</b>
The credentials and servername are correct, I can read/write to the database with a simple PHP page, no problem. I'm also able to use the credentials to open phpMyAdmin (though on shared hosting the User/Privileges tab is disabled/missing.) Opencart is stuck at this step - and I have no idea where @'10%' is coming from.
What gives?
Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.
User error.What gives?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Why do the login credentials work on a simple PHP page but not in the Opencart configuration? What error did I make that needs correcting?
Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.
And for the record, I googled and search the Opencart forums, but didn't find a post or article that addressed the question as I asked it.
Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.
1. this here IS OpenCart (not any other thing ..)tailor@seamlyne.com wrote: ↑Sat Jan 30, 2021 1:25 pmWhy do the login credentials work on a simple PHP page but not in the Cubecart configuration? What error did I make that needs correcting?
2. please read this here viewtopic.php?f=176&t=200480 and post afterwards what is NEEDED
3. from where do you have the installer package
After letting us know the minimum, maybe we can help you.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Sorry, yes, Opencart. Stupid mistake.OSWorX wrote: ↑Sat Jan 30, 2021 4:06 pm1. this here IS OpenCart (not any other thing ..)
2. please read this here viewtopic.php?f=176&t=200480 and post afterwards what is NEEDED
3. from where do you have the installer package
After letting us know the minimum, maybe we can help you.
Version: 3.0.3.6, downloaded from the Opencart website.
No theme (Opencart not installed yet)
No plugins (Opencart not installed yet)
Debian OS (domain.com)
PHP 7.4.10
MySQL 5.6.32
On Step 3 of installation, after clicking the "Continue" button, I get the following error message:
Access denied for user 'my-user'@'{either a server name or %10?}'
Using the same credentials and server info, a vanilla PHP page in the Opencart root folder using MySQLi is able to connect and interact with the database. I need to know if this is a hosting error or an Opencart error so that I can address it and get my client's site setup. Because the vanilla PHP page has no problem, I'm leaning toward something in Opencart, but the code referenced in the error messages doesn't look substantively different from vanilla.
Thanks!
Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.
Which is why, Vanilla is not supported on the forum.tailor@seamlyne.com wrote: ↑Sun Jan 31, 2021 12:43 amSorry, yes, Opencart. Stupid mistake.OSWorX wrote: ↑Sat Jan 30, 2021 4:06 pm1. this here IS OpenCart (not any other thing ..)
2. please read this here viewtopic.php?f=176&t=200480 and post afterwards what is NEEDED
3. from where do you have the installer package
After letting us know the minimum, maybe we can help you.
Version: 3.0.3.6, downloaded from the Opencart website.
No theme (Opencart not installed yet)
No plugins (Opencart not installed yet)
Debian OS (domain.com)
PHP 7.4.10
MySQL 5.6.32
On Step 3 of installation, after clicking the "Continue" button, I get the following error message:
Access denied for user 'my-user'@'{either a server name or %10?}'
Using the same credentials and server info, a vanilla PHP page in the Opencart root folder using MySQLi is able to connect and interact with the database. I need to know if this is a hosting error or an Opencart error so that I can address it and get my client's site setup. Because the vanilla PHP page has no problem, I'm leaning toward something in Opencart, but the code referenced in the error messages doesn't look substantively different from vanilla.
Thanks!
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
So you don't support Opencart, which is the subject of my question?straightlight wrote: ↑Sun Jan 31, 2021 3:31 amWhich is why, Vanilla is not supported on the forum.tailor@seamlyne.com wrote: ↑Sun Jan 31, 2021 12:43 amSorry, yes, Opencart. Stupid mistake.OSWorX wrote: ↑Sat Jan 30, 2021 4:06 pm1. this here IS OpenCart (not any other thing ..)
2. please read this here viewtopic.php?f=176&t=200480 and post afterwards what is NEEDED
3. from where do you have the installer package
After letting us know the minimum, maybe we can help you.
Version: 3.0.3.6, downloaded from the Opencart website.
No theme (Opencart not installed yet)
No plugins (Opencart not installed yet)
Debian OS (domain.com)
PHP 7.4.10
MySQL 5.6.32
On Step 3 of installation, after clicking the "Continue" button, I get the following error message:
Access denied for user 'my-user'@'{either a server name or %10?}'
Using the same credentials and server info, a vanilla PHP page in the Opencart root folder using MySQLi is able to connect and interact with the database. I need to know if this is a hosting error or an Opencart error so that I can address it and get my client's site setup. Because the vanilla PHP page has no problem, I'm leaning toward something in Opencart, but the code referenced in the error messages doesn't look substantively different from vanilla.
Thanks!
Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.
We do support Opencart but not Vanilla.tailor@seamlyne.com wrote: ↑Sun Jan 31, 2021 4:50 amSo you don't support Opencart, which is the subject of my question?straightlight wrote: ↑Sun Jan 31, 2021 3:31 amWhich is why, Vanilla is not supported on the forum.tailor@seamlyne.com wrote: ↑Sun Jan 31, 2021 12:43 am
Sorry, yes, Opencart. Stupid mistake.
Version: 3.0.3.6, downloaded from the Opencart website.
No theme (Opencart not installed yet)
No plugins (Opencart not installed yet)
Debian OS (domain.com)
PHP 7.4.10
MySQL 5.6.32
On Step 3 of installation, after clicking the "Continue" button, I get the following error message:
Access denied for user 'my-user'@'{either a server name or %10?}'
Using the same credentials and server info, a vanilla PHP page in the Opencart root folder using MySQLi is able to connect and interact with the database. I need to know if this is a hosting error or an Opencart error so that I can address it and get my client's site setup. Because the vanilla PHP page has no problem, I'm leaning toward something in Opencart, but the code referenced in the error messages doesn't look substantively different from vanilla.
Thanks!
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Forget Vanilla, Vanille, Strawberry and co ..tailor@seamlyne.com wrote: ↑Sun Jan 31, 2021 12:43 amOn Step 3 of installation, after clicking the "Continue" button, I get the following error message:
Access denied for user 'my-user'@'{either a server name or %10?}'
You have created before starting the OpenCart Installation the database login data?
User and password?
Have you ever tried to use those data - without any special and other characters than a-z and/or A-Z and/or 0-9
Just to see if those are working.
And maybe once with php 7.3.x
One final note:
You know that this forum should help users, not Agencies?
So, if this is a "Client" of you, you get paid.
Therefore either you have the knowledge for such operations, or you have to pay another OpenCart Professional!
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
tailor@seamlyne.com wrote: ↑Sun Jan 31, 2021 12:43 amVersion: 3.0.3.6, downloaded from the Opencart website.
No theme (Opencart not installed yet)
No plugins (Opencart not installed yet)
He say that credentials work on a PHP vanilla page but not to install opencart.
To understand I give you an example:
- same database info wok to install Wordpress
- same database info doesn't work to install Opencart.
@tailor
Check again if the password is correct and the database user has all privileges for that database.
And if you have Softaculous you can try to install automatically in a folder to see if work.
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
Exactly. Which is why, Opencart.com provides an installation wizard out-of-the-box where 3rd party installation packages are not supported.He say that credentials work on a PHP vanilla page but not to install opencart.
To understand I give you an example:
- same database info wok to install Wordpress
- same database info doesn't work to install Opencart.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
He entered database name, password etc.. on opencart installation and didn't work.
He entered database name, password etc.. on something else and worked...connection ok...
So dind't ask for help how to install a 3rd app.
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
Yes, this is the part of my reply that is covered about.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Users browsing this forum: Semrush [Bot] and 49 guests