Cannot Create or Change Database

desertflyer · Post by **desertflyer** » Thu Feb 20, 2014 1:49 am

Hello,

I am getting the following error when I try to make a new database:

I also cannot make changes to existing databases. I changed the MySQL root password, so is that the problem? Thanks for any help you can provide.

Joshua · Post by **Joshua** » Thu Feb 20, 2014 2:08 am

Try editing the mysql.conf file located in the "/usr/local/vesta/conf" directory.

It should start like this:

Code: Select all

HOST='localhost' USER='root' PASSWORD='password'

Update the password with your new MySQL root password, restart vesta and it should be fixed.

desertflyer · Post by **desertflyer** » Thu Feb 20, 2014 2:15 am

That fixed it. Thank you, Joshua, for helping a novice like me learn!

ducnb · Post by **ducnb** » Sat Aug 01, 2015 1:44 am

Please see this image:

I dont know why, before it show in host field is "localhost" but now, it's empty and I cant create new database.
Please help me.

Post by **skurudo** » Sat Aug 01, 2015 3:32 pm

ducnb wrote:Please see this image:

I dont know why, before it show in host field is "localhost" but now, it's empty and I cant create new database.
Please help me.

viewtopic.php?f=10&t=5326&start=10#p30042 - reinstall solved problem or not?

Vesta Control Panel - Forum