phpMyadmin

[Farrow]

I have a problem with roundcube data base connection, Ive read the tut about adding the tables for the database but I am unable to login as root user to phpmyadmin. Ive tried the password giving when vesta is installed, Ive also tried the password for my VPS. Is there a default password to login as root?

Any advice would be greatly appreciated.

[imperio]

Hi, you can find mysql root password in this files
/usr/local/vesta/conf/mysql.conf

Code: Select all

USER='root' PASSWORD=''

or

Code: Select all

/root/.my.cnf

passwords for root vps and root mysql is different

[Farrow]

Thank you very much for the reply.
When I change root password I get error when trying to add database:
Adding database → Error: Connection failed

Is there another file I have to update the new password?

[imperio]

if you changed mysql root password in the ssh, also you should add him to mysql.conf
/usr/local/vesta/conf/mysql.conf

[Farrow]

I looked in /usr/local/vesta/conf/mysql.conf and could not see any where to change pass.

Code: Select all

WEB_SYSTEM='httpd'
WEB_RGROUPS='apache'
WEB_PORT='8080'
WEB_SSL='mod_ssl'
WEB_SSL_PORT='8443'
PROXY_SYSTEM='nginx'
PROXY_PORT='80'
PROXY_SSL_PORT='443'
FTP_SYSTEM='vsftpd'
MAIL_SYSTEM='exim'
IMAP_SYSTEM='dovecot'
ANTIVIRUS_SYSTEM=''
ANTISPAM_SYSTEM=''
DB_SYSTEM='mysql'
DNS_SYSTEM='named'
STATS_SYSTEM='webalizer,awstats'
BACKUP_SYSTEM='local'
CRON_SYSTEM='crond'
DISK_QUOTA='no'
REPOSITORY='cmmnt'
VERSION='0.9.8'
LANGUAGE='en'

[imperio]

/usr/local/vesta/conf/mysql.conf
do you have mysql.conf file in this directory /usr/local/vesta/conf/ ?

[Farrow]

Yes I have that file. If I change the password in /usr/local/vesta/conf/mysql.conf
I can not connect to databases from the panel, I can not add databases or delete them from the panel.
It gives error:
Adding database → Error: Connection failed

[imperio]

take the password in the /root/.my.cnf
and add this password in mysql.conf
/usr/local/vesta/conf/mysql.conf

Code: Select all

PASSWORD='password from my.cnf'

[Farrow]

I got it now.
Thank you very much.

[morcom]

Me too - thanks for the answer