MySQL Installation Error

[neumartin]

Operating System (OS/VERSION):

Debian 9

VestaCP Version:

0.9.8-22

Installed Software (what you got with the installer):

bash vst-install.sh --nginx no --apache yes --phpfpm no --named yes --remi no --vsftpd yes --proftpd no --iptables yes --fail2ban yes --quota yes --exim yes --dovecot yes --spamassassin yes --clamav yes --softaculous yes --mysql yes --postgresql yes

Steps to Reproduce:

Just install and you will se this errors:

Creating config file /etc/roundcube/debian-db.php with new version ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory"). unable to connect to mysql server. error encountered creating user: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") dbconfig-common: roundcube configure: noninteractive fail. dbconfig-common: roundcube configure: ignoring errors from here forwards populating database via sql... done. dbconfig-common: flushing administrative password apache2_invoke: Enable configuration roundcube.conf invoke-rc.d: policy-rc.d denied execution of reload. invoke-rc.d: policy-rc.d denied execution of reload. Setting up tk8.6 (8.6.6-1+b1) ... Setting up libapache2-mod-php (1:7.0+49) ... Setting up php7.0 (7.0.30-0+deb9u1) ... Setting up roundcube-plugins (1.2.3+dfsg.1-4+deb9u2) ... Setting up spamassassin (3.4.1-6+deb9u1) ... Adding system user debian-spamd' (UID 116) ... Adding new groupdebian-spamd' (GID 122) ... Adding new user debian-spamd' (UID 116) with groupdebian-spamd' ... Creating home directory `/var/lib/spamassassin' ... Setting up x11-utils (7.7+3+b1) ... Setting up ghostscript (9.20~dfsg-3.2+deb9u4) ... Setting up xterm (327-2) ... update-alternatives: using /usr/bin/xterm to provide /usr/bin/x-terminal-emulator (x-terminal-emulator) in auto mode update-alternatives: using /usr/bin/lxterm to provide /usr/bin/x-terminal-emulator (x-terminal-emulator) in auto mode Setting up libpangoft2-1.0-0:amd64 (1.40.5-1) ... Setting up libcupsfilters1:amd64 (1.11.6-3) ... Setting up phpmyadmin (4:4.6.6-4) ... Determining localhost credentials from /etc/mysql/debian.cnf: succeeded. dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf

Creating config file /etc/dbconfig-common/phpmyadmin.conf with new version

Creating config file /etc/phpmyadmin/config-db.php with new version ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory"). unable to connect to mysql server. error encountered creating user: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

[dpeca]

by the way, this can be fixed after installation this way - https://forum.vestacp.com/viewtopic.php?f=14&t=10307&p=71828#p71828

[tudorr89]

Edit: As @dpeca mentioned, access to phpmyadmin for root is disabled for security reasons by Debian. To fix it, do the following:

sudo mysql -u root ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOUR_PASSWORD'; FLUSH PRIVILEGES;

[dpeca]

It's not broken, it's disabled for security reason by Debian distribution itself.