Page 1 of 1

How to Fix Adding database in VestaCP with MySql 5.7

Posted: Wed Apr 12, 2017 6:56 am
by riddict
Hi

Firstly, I want to say thanks for this wonderful panel.
After sometime using VestaCP, I came across to the moment where I need to upgrade MySql from version 5.5 to 5.7. After successfully upgrade MySql version. I am facing problem in creating new database along with the user, after looked in this forum,I found the solution by editing vesta configuration and assign the new mysql root password. However, after successfully creating the new database, the user for this database itself cannot be used (access denied for user).

After check db.conf file, md5 password for that user is empty. I am using Centos 7.

Re: How to Fix Adding database in VestaCP with MySql 5.7

Posted: Fri Apr 21, 2017 4:17 pm
by ScIT
If you still have this problem, have a look here: viewtopic.php?t=13239

Re: How to Fix Adding database in VestaCP with MySql 5.7

Posted: Tue Aug 29, 2017 2:58 pm
by dimahna
ScIT wrote:If you still have this problem, have a look here: viewtopic.php?t=13239
i have the same as this man i use centos 6.7

Re: How to Fix Adding database in VestaCP with MySql 5.7

Posted: Thu Aug 31, 2017 1:06 pm
by skurudo
dimahna wrote:i have the same as this man i use centos 6.7
And which version of mysql do you have?