Once our vestacp installation was finished, we had to import a file SQL , unfortunately phpadmin shipped by vestacp did not work properly with the following error:
#1142 – SELECT command denied to user ”@’localhost’ for table ‘pma_table_uiprefs’
A few suggestion to fix the issue, i decided to execute this command first before trying other solutions :
curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh && chmod +x pma-debian.sh && ./pma-debian.sh
Voila it works fine, please note that command only working with debian . if you are using different linux distro , have a look here :
https://github.com/skurudo/phpmyadmin-fixer
The script can be implemented however you don’t use vestacp , (not limited to vestacp version only )