How to Fix Adding database in VestaCP with MySql 5.7

riddict · Post by **riddict** » Wed Apr 12, 2017 6:56 am

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.

Post by **ScIT** » Fri Apr 21, 2017 4:17 pm

If you still have this problem, have a look here: viewtopic.php?t=13239

dimahna · Post by **dimahna** » Tue Aug 29, 2017 2:58 pm

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

Post by **skurudo** » Thu Aug 31, 2017 1:06 pm

dimahna wrote:i have the same as this man i use centos 6.7

And which version of mysql do you have?

Vesta Control Panel - Forum