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)'
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.
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?
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.