Phpmyadmin cant open any table
Phpmyadmin cant open any table
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!
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!
-
- Posts: 139
- Joined: Thu Jan 07, 2016 12:01 am
Re: Phpmyadmin cant open any table
It's a long drawn out process, but: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!
https://wiki.phpmyadmin.net/pma/Configuration_storage
Re: Phpmyadmin cant open any table
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!
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!
Re: Phpmyadmin cant open any table
Ok, I'll answer myself. Here is the solution: viewtopic.php?f=14&t=10307
Re: Phpmyadmin cant open any table
Yeah, it's my fix for all humankind.neiklot wrote:Ok, I'll answer myself. Here is the solution: viewtopic.php?f=14&t=10307
I tried to find all topics with this error and inform about the fix, but found not all :)
-
- Posts: 1
- Joined: Wed Aug 03, 2016 3:30 am
Re: Phpmyadmin cant open any table
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.
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.
Re: Phpmyadmin cant open any table
And this viewtopic.php?f=14&t=10307 solution don't ?shambhu123 wrote: It worked for me.