(Jan 22) Release 0.9.8-19 with bug fixes available now. Run this command for update v-update-sys-vesta-all

mysql permissions bug

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
Posts: 28
Joined: Sun Apr 06, 2014 8:47 pm

mysql permissions bug

Postby Messiah » Wed May 10, 2017 7:31 pm


I've just installed latest version of VesaCP at clear Debian8 server, all settings are default.
Then I added a web domain (+dns +mail), deleted default mysql database and created a new one for this website.
Using phpmyadmin I imported a sql dump, the site was OK. Then I installed LetsEncrypt SSL and edited some php scripts. This time the phpmyadmin session expired. When I logged in there again, I was not able to view any table contents due to
#1142 - SELECT command denied to user 'admin_***'@'localhost' for table 'pma_table_uiprefs'

error. Still I was able to view the table structure. Shit happens. I changed mysql user password using VestaCP, the same. There is a message about an controluser configuration errors in the page footer.

Some time ago I installed VestaCP at different VPS, there were problems with webmail. Everything ended when I installed clean webmail distribution into / of my own subdomain named mail and set that path in control panel config.
I've never experienced such problems with old VestaCP versions, everything MUST work from the box as it was before.
Of course I can fix it manually what I will do now, but why? There was a great benefit of VestaCP, when any user without an experience could install and use it, now it seems only experienced users may do it.

VestaCP Team
Posts: 7808
Joined: Fri Dec 26, 2014 2:23 pm

Re: mysql permissions bug

Postby skurudo » Fri May 12, 2017 11:16 am

I hope, you can found answer here:

PS: Moved to Database Server
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

Return to “Database Server”

Who is online

Users browsing this forum: No registered users and 2 guests