mysql.conf not found in /usr/local/vesta/conf

[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

[joem]

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/local/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=''

Code: Select all

Ctrl X
Y
Enter

[icky.firmansyah]

thx a lot dude..
worked perfectly..

:D