mysql permissions bug

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Messiah
Posts: 22
Joined: Sun Apr 06, 2014 8:47 pm

mysql permissions bug

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

Hello,

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.

skurudo
VestaCP Team
Posts: 7511
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: mysql permissions bug

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

I hope, you can found answer here:
viewtopic.php?f=14&t=10307

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 1 guest