How to Fix Adding database in VestaCP with MySql 5.7
Posted: 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.
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.