Vesta Control Panel - Forum

If, like me you are running Ubuntu 14.04 (& probably others), and having DB issues with "can't login", then the problem seems to be due to the mysql config missing a "bind-address" setting.

Edit /etc/mysql/my.cnf and add the missing "bind-address" line to the [mysqld] section:

[mysqld]
...
bind ...

On Ubuntu 14.04 I found that I needed to change 'localhost' to '127.0.0.1' in /var/lib/roundcube/config/db.inc.php
$rcmail_config['db_dsnw'] = 'mysql://roundcube:<YOURPASSWORD>@127.0.0.1/roundcube';

Then, voila!

EDIT: I found that editing /etc/mysql/my.cnf and adding "bind-address=127.0.0.1 ...

I'm not sure if this information is relevant to you all, but check out Stack Overflow: http://stackoverflow.com/questions/3694575/phpmyadmin-is-throwing-a-2002-cannot-log-in-to-the-mysql-server-phpmyadmin

If that bug sounds like you, then read on:

EDIT: Read my next comment, which is a better fix ...