We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
How to Fix Adding database in VestaCP with MySql 5.7
How to Fix Adding database in VestaCP with MySql 5.7
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.
Re: How to Fix Adding database in VestaCP with MySql 5.7
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
i have the same as this man i use centos 6.7ScIT wrote: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
And which version of mysql do you have?dimahna wrote:i have the same as this man i use centos 6.7