Cannot Select Database `if0_37984521_doai` - User `if0_37984521` (Account if0_37984521)

Hosting Support
1

Website URL

  • http://doai.ct.ws
  • http://doai.id.vn

Error Message

After configuring wp-config.php with credentials from my Client Area, I consistently get this error (or the WordPress “Cannot select database” page):

Warning: mysqli_real_connect(): (HY000/1045): Access denied for user ‘if0_37984521’@‘192.168.0.%’ to database ‘if0_37984521_doai’ (This error occurred in /home/vol9_5/infinityfree.com/if0_37984521/htdocs/wp-includes/class-wpdb.php on line 1988)

Access denied for user ‘if0_37984521’@‘192.168.0.%’ (using password: YES)

Cannot select database The database server could be connected to (which means your username and password is okay) but the if0_37984521_doai database could not be selected.

(This is the most recent error I’m seeing, based on screenshot

image
image795×461 14.8 KB

.

Other Information

(other information and details relevant to your question)

  • My InfinityFree Account Username: if0_37984521 (as shown in Client Area “MySQL Connection Details”).
  • Database in Question: My original WordPress data is in database if0_37984521_doai on host sql101.byetcluster.com. I can see this database and its tables/data in phpMyAdmin.
  • wp-config.php Settings Used:
    • DB_NAME: 'if0_37984521_doai'
    • DB_USER: 'if0_37984521'
    • DB_PASSWORD: [Correct Password from Client Area "MySQL Connection Details"]
    • DB_HOST: 'sql101.infinityfree.com' (from Client Area) - I have also tried sql101.byetcluster.com (from phpMyAdmin) with the same “Cannot select database” result.
  • Critical Issue: My Client Area (“MySQL Databases” page) and VistaPanel (“MySQL Databases” page) BOTH show “No databases found on this account”. This means I cannot see or manage my existing database if0_37984521_doai through the control panels, nor can I verify or assign user privileges to it.
  • Assistance Sought: I am a newbie and have been trying to troubleshoot this for a long time, including using AI assistance to understand the errors and suggest solutions. The current error “Cannot select database” (even though user/password for the MySQL server seem okay) strongly suggests an issue with user if0_37984521 not having the necessary permissions for the database if0_37984521_doai.

Request:

Since my control panels show “No databases found” and I cannot manage user privileges for my existing database if0_37984521_doai:

  1. Could you please investigate why my database if0_37984521_doai (on host sql101.byetcluster.com, containing my data) is not listed in my account’s “MySQL Databases” management pages?
  2. Can you please ensure that my MySQL user if0_37984521 (associated with my account) is correctly assigned with ALL PRIVILEGES to my database if0_37984521_doai?
  3. Please clarify the definitive DB_HOST to use with user if0_37984521 for database if0_37984521_doai.

I believe this is a system-level issue with database visibility and permissions that is preventing my WordPress site from connecting.

Thank you for your detailed assistance.

2

Did you create the database? Create the database in the control panel. If it is empty, you need to install the WP DB.

3 Likes
3

No my database is empty, what should I do next

image
image1871×914 72.9 KB

This is my AI reply (I think it understand context than me)
Hi @Greenreader9,

Thank you for your reply.

To clarify the situation:

  1. I do have an existing WordPress database named if0_37984521_doai on host sql101.byetcluster.com. I can see this database and all my WordPress tables and data (approx 5MB) when I access phpMyAdmin (as shown in a previous screenshot I can provide, image_e5f8c7.jpg). This is my original database.

  2. The main problem is that this existing database if0_37984521_doai is NOT listed in my Client Area’s “MySQL Databases” page or in VistaPanel’s “MySQL Databases” page. Both these pages show “No databases found on this account” or an empty list (as shown in screenshots image_16638b.png and image_165f4e.png I can provide).

  3. Because this database isn’t listed in the control panels, I cannot manage it or assign user privileges to it via the panel.

  4. My wp-config.php is attempting to connect to this existing database if0_37984521_doai using the username if0_37984521 (from my Client Area’s MySQL Connection Details) and my account password.

  5. The error I get is “Cannot select database if0_37984521_doai”, which occurs after the PHP warning “Access denied for user ‘if0_37984521’@‘…’ to database ‘if0_37984521_doai’”. This indicates the MySQL server connection with user if0_37984521 and password might be okay, but this user then lacks permission to select/use the if0_37984521_doai database.

Could you please look into why my existing database if0_37984521_doai is not appearing in my account’s database management panels and ensure that the user if0_37984521 has ALL PRIVILEGES correctly assigned to this database?

I don’t need to create a new database or install a new WP DB, as my data already exists in if0_37984521_doai. The issue seems to be with the system not recognizing/listing this database under my account properly for privilege management.

Thank you.

4

Create the database in the control panel, sometimes things get out of sync which causes issues.

Also, please don’t use AI to post here, whatever you prompt the AI with, paste here instead. AI can change your meaning, add irrelevant information, make stuff up, and overall make it much harder to understand what you are really asking.

Also, see:

3 Likes