Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

Phpmyadmin cant open any table

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
7 posts • Page 1 of 1
bam
Posts: 2
Joined: Sat Dec 26, 2015 12:56 am

Phpmyadmin cant open any table
  • Quote

Post by bam » Sat Dec 26, 2015 12:59 am

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!
Top

BBuchanan1013
Posts: 139
Joined: Thu Jan 07, 2016 12:01 am

Re: Phpmyadmin cant open any table
  • Quote

Post by BBuchanan1013 » Thu Jan 07, 2016 1:25 am

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
Top

neiklot
Posts: 13
Joined: Tue Jan 19, 2016 9:56 am

Re: Phpmyadmin cant open any table
  • Quote

Post by neiklot » Tue Jan 19, 2016 9:59 am

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!
Top

neiklot
Posts: 13
Joined: Tue Jan 19, 2016 9:56 am

Re: Phpmyadmin cant open any table
  • Quote

Post by neiklot » Tue Jan 19, 2016 10:30 am

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

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Phpmyadmin cant open any table
  • Quote

Post by skurudo » Tue Jan 19, 2016 1:31 pm

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 :)
Top

shambhu123
Posts: 1
Joined: Wed Aug 03, 2016 3:30 am

Re: Phpmyadmin cant open any table
  • Quote

Post by shambhu123 » Wed Aug 03, 2016 3:34 am

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.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Phpmyadmin cant open any table
  • Quote

Post by skurudo » Wed Aug 03, 2016 5:06 am

shambhu123 wrote: It worked for me.
And this viewtopic.php?f=14&t=10307 solution don't ?
Top


Post Reply
  • Print view

7 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password