Vesta Control Panel - Forum

when i try open any table on phpmyadmin i got error #1142 - SELECT command denied to user 'user'@'localhost' for table 'pma_table_uiprefs'
on root #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist
how to fix it ?
ubuntu 15.04
Happy Christmas and new year for all!

bam wrote:when i try open any table on phpmyadmin i got error #1142 - SELECT command denied to user 'user'@'localhost' for table 'pma_table_uiprefs'
on root #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist
how to fix it ?
ubuntu 15.04
Happy Christmas and new year for all!

It's a long drawn out process, but:
https://wiki.phpmyadmin.net/pma/Configuration_storage

Same problem here. I just installed debian 8 and vestacp, everything by default and when I create a new db and I create a new table using vestacp, this error happens.

I can try to solve it but, does anyone know why is this happening? did i do something wrong or is this some vestacp issue?

Thank you very much!

Ok, I'll answer myself. Here is the solution: viewtopic.php?f=14&t=10307

neiklot wrote:Ok, I'll answer myself. Here is the solution: viewtopic.php?f=14&t=10307

Yeah, it's my fix for all humankind.

I tried to find all topics with this error and inform about the fix, but found not all :)

Hi,
There is issue with phpmyadmin configuration, You just go to https://www.phpmyadmin.net/downloads/ and download completable version of phpmyadmin and extract and than upload at you public_html, Now your phpmyadmin url will be http://domainname.com/phpmyadmin and login database,

It worked for me.

shambhu123 wrote: It worked for me.

And this viewtopic.php?f=14&t=10307 solution don't ?