MySQL error 1044 — Access denied despite database being visible in phpMyAdmin

[danewwstart]

Website URL

https://satisfy.site.je/validar_login.php

Error Message

Access denied for user ‘if0_43178354’@‘192.168.%’ to database ‘if0_43178354_XXX’

Other Information

I can access the database via phpMyAdmin and view the tables, but the PHP page fails to connect.
The error occurs with both MySQLi and PDO.

I have checked the database name, MySQL username, and hostname against my hosting control panel.

[system]

Welcome to the InfinityFree community forum! Good to have you here.

• Most people answering here are volunteers. They’re often the fastest source of help. Admin (the only staff member) checks in about once a day for issues on our end.
• Volunteers can’t see your account or website. Share what you actually see, like error messages and what happens when you try something. That’s more useful than your theory of what’s wrong.
• AI tools often get InfinityFree wrong. If a volunteer’s advice differs from what an AI told you, please try the volunteer’s suggestion first.
• Solving an issue is a joint effort. Try the suggestions you get and report back what happened.

[Lemni]

Beep boop, I’m a bot! I dug through the forum to get you started. I sometimes get things wrong though, so do with this what you will until a human has a look.

Error 1044 with the '192.168.%' part usually means the login worked but the database name you gave isn’t one that user can use. I found a knowledge base article that covers this exact message:

Common MySQL Connection Errors

Many websites use MySQL databases to store information and settings. However, there are some reasons why the connection to the database may fail. This article describes some commonly seen error messages when connecting to a database, as well as some general tips to keep in mind when setting up a database connection. Common Error Messages Using MySQL is great, but the error message returned if there is an issue logging in to your database can be quite confusing. Here are some commonly seen error…

It says the usual causes are a database name that isn’t exactly the full name from the control panel, or a wrong database password. The password is your hosting account password, not your client area password. You can find it in the client area under the account’s MySQL Details.

Both the name and the password could be wrong in your script even when phpMyAdmin works. You get into phpMyAdmin through the control panel, so you never type either one there.

Could you check that the database name in your PHP config matches the one listed under MySQL Databases in the control panel, character for character? Include the if0_43178354_ prefix and the part after it, with no extra spaces. Then tell me whether it matches, and where your script gets the password from.

You don’t need to delete or recreate anything. The article doesn’t suggest that for this error.

[Admin]

99% of the time it’s indeed the database name. There have been a few topics this week about this error, and every time it was a typo in the database name.

I can check it for your if you want. But to clarify, is if0_43178354_XXX the actual database name or just the placeholder? Because if it’s a placeholder, then please share the full error message you get on your site exactly as shown.

[danewwstart]

I´m actually not sure about it being the name or the placeholder. This is the full error message:

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1044] Access denied for user ‘if0_43178354’@‘192.168.%’ to database ‘if0_43178354_XXX’ in /home/vol1_4/infinityfree.com/if0_43178354/htdocs/validar_login.php:4 Stack trace: #0 /home/vol1_4/infinityfree.com/if0_43178354/htdocs/validar_login.php(4): PDO->__construct(‘mysql:host=sql2…’, ‘if0_43178354’, Object(SensitiveParameterValue)) #1 {main} thrown in /home/vol1_4/infinityfree.com/if0_43178354/htdocs/validar_login.php on line **4
**
It would be great if you could check for me and help me fix it, I´d appreciate it.
Thank you.

[dan3008]

from your error message, you’re trying to access databse ‘if0_43178354_XXX’

you’ll need to change this in your code to your actual database name

[Admin]

I just noticed something that I think might explain the confusion.

On the MySQL Databases page in the members area, you can see two cards: the MySQL Connection Details and the List of MySQL Databases.

In the MySQL Connection Details, it lists your MySQL Database Name as if0_43178354_XXX. However, that’s a placeholder value. It’s not necessarily an actual database name. The actual database names are shown in the list of databases in the card below.

So to connect your website to the database, the database name setting in your website must be the matching database in the list, not the placeholder value.