Page 1 of 1
Cannot Create or Change Database
Posted: Thu Feb 20, 2014 1:49 am
by desertflyer
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.
Re: Cannot Create or Change Database
Posted: Thu Feb 20, 2014 2:08 am
by Joshua
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.
Re: Cannot Create or Change Database
Posted: Thu Feb 20, 2014 2:15 am
by desertflyer
That fixed it. Thank you, Joshua, for helping a novice like me learn!
Re: Cannot Create Database
Posted: Sat Aug 01, 2015 1:44 am
by ducnb
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.
Re: Cannot Create Database
Posted: Sat Aug 01, 2015 3:32 pm
by skurudo
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?