phpMyAdmin error: "pma__column_info doesn't exist" – Cannot access database at all

Hosting Support
1

Hello,

I’m unable to access my database through phpMyAdmin. Every time I click on phpMyAdmin from the InfinityFree control panel, I get this error:

Error

SQL query:

SELECT `comment`
                FROM `if0_39123428_godpact_db`.`pma__column_info`
                WHERE db_name     = 'if0_39123428_godpact'
                    AND table_name  = ''
                    AND column_name = '(db_comment)'

**MySQL said:

`#1146 - Table 'if0_39123428_godpact_db.pma__column_info' doesn't exist`

This error completely blocks me from using phpMyAdmin — I can’t view or manage any tables or databases at all.

I understand this may be related to phpMyAdmin’s internal configuration storage (like the pma__ tables), but I don’t have access to fix this myself. Please reset or reconfigure phpMyAdmin so I can use it properly again.

Thanks in advance for your help!

2

Welcome to the forum @Stephen4000 !!
can you share the screenshot of the error for better reference? Also maybe the error is getting cached, so clear the cache and try again maybe?

3

The error i posted previously is all the page had and this:

**MySQL said:

`#1146 - Table 'if0_39123428_godpact_db.pma__column_info' doesn't exist`
that was all, there were no other texts in the page
4

It seems to be working now for some reason. it no longer shows that erro when i want to access my database

5

Don’t include the table name in your query, instead, connect to the individual database when you create the connection. As credentials are unique to each DB on free hosting, you don’t need to specify a database after logging in. This approach also makes it easier to migrate your website should you ever need to.