We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
phpMyadmin
phpMyadmin
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.
Any advice would be greatly appreciated.
Re: phpMyadmin
Hi, you can find mysql root password in this files
/usr/local/vesta/conf/mysql.conf
or
passwords for root vps and root mysql is different
/usr/local/vesta/conf/mysql.conf
Code: Select all
USER='root' PASSWORD=''
Code: Select all
/root/.my.cnf
Re: phpMyadmin
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?
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
if you changed mysql root password in the ssh, also you should add him to mysql.conf
/usr/local/vesta/conf/mysql.conf
/usr/local/vesta/conf/mysql.conf
Re: phpMyadmin
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
/usr/local/vesta/conf/mysql.conf
do you have mysql.conf file in this directory /usr/local/vesta/conf/ ?
do you have mysql.conf file in this directory /usr/local/vesta/conf/ ?
Re: phpMyadmin
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
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
take the password in the /root/.my.cnf
and add this password in mysql.conf
/usr/local/vesta/conf/mysql.conf
and add this password in mysql.conf
/usr/local/vesta/conf/mysql.conf
Code: Select all
PASSWORD='password from my.cnf'
Re: phpMyadmin
I got it now.
Thank you very much.
Thank you very much.