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

mysql permissions bug

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
2 posts • Page 1 of 1
Messiah
Posts: 74
Joined: Sun Apr 06, 2014 8:47 pm

mysql permissions bug
  • Quote

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

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

Re: mysql permissions bug
  • Quote

Post by 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
Top


Post Reply
  • Print view

2 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