Page 1 of 2

phpMyadmin

Posted: Fri May 16, 2014 4:24 pm
by 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.

Re: phpMyadmin

Posted: Fri May 16, 2014 5:22 pm
by 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

Re: phpMyadmin

Posted: Fri May 16, 2014 6:03 pm
by 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?

Re: phpMyadmin

Posted: Fri May 16, 2014 6:25 pm
by imperio
if you changed mysql root password in the ssh, also you should add him to mysql.conf
/usr/local/vesta/conf/mysql.conf

Re: phpMyadmin

Posted: Fri May 16, 2014 6:31 pm
by 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'

Re: phpMyadmin

Posted: Fri May 16, 2014 6:43 pm
by imperio
/usr/local/vesta/conf/mysql.conf
do you have mysql.conf file in this directory /usr/local/vesta/conf/ ?

Re: phpMyadmin

Posted: Fri May 16, 2014 7:01 pm
by 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

Re: phpMyadmin

Posted: Fri May 16, 2014 7:16 pm
by 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'

Re: phpMyadmin

Posted: Fri May 16, 2014 7:23 pm
by Farrow
I got it now.
Thank you very much.

Re: phpMyadmin

Posted: Sat May 17, 2014 1:39 pm
by morcom
Me too - thanks for the answer