Page 1 of 1
mysql.conf not found in /usr/local/vesta/conf
Posted: Thu Jan 01, 2015 5:25 pm
by icky.firmansyah
hy .. i cant add db in my vestacp..
because host is blank..
and i search file mysql.conf but not found in /usr/loca/vesta/conf
can someone help me how to fix it?
ty
Re: mysql.conf not found in /usr/local/vesta/conf
Posted: Thu Jan 01, 2015 9:41 pm
by joem
icky.firmansyah wrote:hy .. i cant add db in my vestacp..
because host is blank..
and i search file mysql.conf but not found in /usr/loca/vesta/conf
can someone help me how to fix it?
ty
Run from ssh Change NewPass to a new root password. Also /usr/loca/vesta/conf should be /usr/loca
l/vesta/conf
Code: Select all
mysql
UPDATE mysql.user SET Password=PASSWORD('NewPass') WHERE User='root';
FLUSH PRIVILEGES;
exit
nano /usr/local/vesta/conf/mysql.conf
Paste this in there
HOST='localhost' USER='root' PASSWORD='NewPass' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='admin' U_DB_BASES='0' SUSPENDED='no' TIME='' DATE=''
Re: mysql.conf not found in /usr/local/vesta/conf
Posted: Fri Jan 02, 2015 6:58 am
by icky.firmansyah
thx a lot dude..
worked perfectly..
:D