Post by tailor@seamlyne.com » Sat Jan 30, 2021 10:00 am

Getting the error

'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 avatar

Posts

Joined
Thu Nov 09, 2017 9:43 am
Location - Kansas City, Missouri

Post by straightlight » Sat Jan 30, 2021 12:41 pm

What gives?
User error.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

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

Post by tailor@seamlyne.com » Sat Jan 30, 2021 1:25 pm

straightlight wrote:
Sat Jan 30, 2021 12:41 pm
What gives?
User error.
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?
Last edited by tailor@seamlyne.com on Sun Jan 31, 2021 12:45 am, edited 1 time in total.

Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.


User avatar

Posts

Joined
Thu Nov 09, 2017 9:43 am
Location - Kansas City, Missouri

Post by tailor@seamlyne.com » Sat Jan 30, 2021 1:44 pm

straightlight wrote:
Sat Jan 30, 2021 12:41 pm
User error.
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.
Last edited by tailor@seamlyne.com on Sun Jan 31, 2021 12:44 am, edited 1 time in total.

Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.


User avatar

Posts

Joined
Thu Nov 09, 2017 9:43 am
Location - Kansas City, Missouri

Post by OSWorX » Sat Jan 30, 2021 4:06 pm

tailor@seamlyne.com wrote:
Sat Jan 30, 2021 1:25 pm
Why do the login credentials work on a simple PHP page but not in the Cubecart configuration? What error did I make that needs correcting?
1. 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.

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by tailor@seamlyne.com » Sun Jan 31, 2021 12:43 am

OSWorX wrote:
Sat Jan 30, 2021 4:06 pm
1. 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.
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!

Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.


User avatar

Posts

Joined
Thu Nov 09, 2017 9:43 am
Location - Kansas City, Missouri

Post by straightlight » Sun Jan 31, 2021 3:31 am

tailor@seamlyne.com wrote:
Sun Jan 31, 2021 12:43 am
OSWorX wrote:
Sat Jan 30, 2021 4:06 pm
1. 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.
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!
Which is why, Vanilla is not supported on the forum.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

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

Post by tailor@seamlyne.com » Sun Jan 31, 2021 4:50 am

straightlight wrote:
Sun Jan 31, 2021 3:31 am
tailor@seamlyne.com wrote:
Sun Jan 31, 2021 12:43 am
OSWorX wrote:
Sat Jan 30, 2021 4:06 pm
1. 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.
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!
Which is why, Vanilla is not supported on the forum.
So you don't support Opencart, which is the subject of my question?

Bill in Kansas City, MO
Measure with a micrometer. Mark with a crayon. Cut with an ax.


User avatar

Posts

Joined
Thu Nov 09, 2017 9:43 am
Location - Kansas City, Missouri

Post by straightlight » Sun Jan 31, 2021 7:30 am

tailor@seamlyne.com wrote:
Sun Jan 31, 2021 4:50 am
straightlight wrote:
Sun Jan 31, 2021 3:31 am
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!
Which is why, Vanilla is not supported on the forum.
So you don't support Opencart, which is the subject of my question?
We do support Opencart but not Vanilla.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

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

Post by OSWorX » Sun Jan 31, 2021 4:39 pm

tailor@seamlyne.com wrote:
Sun Jan 31, 2021 12:43 am
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?}'
Forget Vanilla, Vanille, Strawberry and co ..

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:
tailor@seamlyne.com wrote:
Sun Jan 31, 2021 12:43 am
.. my client's site setup ..
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.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by xxvirusxx » Sun Jan 31, 2021 4:44 pm

tailor@seamlyne.com wrote:
Sun Jan 31, 2021 12:43 am
Version: 3.0.3.6, downloaded from the Opencart website.
No theme (Opencart not installed yet)
No plugins (Opencart not installed yet)
straightlight wrote:
Sun Jan 31, 2021 7:30 am
We do support Opencart but not Vanilla.
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


User avatar
Expert Member

Posts

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

Post by straightlight » Sun Jan 31, 2021 9:24 pm

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.
Exactly. Which is why, Opencart.com provides an installation wizard out-of-the-box where 3rd party installation packages are not supported.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

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

Post by xxvirusxx » Sun Jan 31, 2021 11:09 pm

You still don't understand....

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


User avatar
Expert Member

Posts

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

Post by straightlight » Sun Jan 31, 2021 11:23 pm

xxvirusxx wrote:
Sun Jan 31, 2021 11:09 pm
You still don't understand....

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.
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


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 9 guests