Hi, Both SSL & non-SSL at <domain>:8080/phpmyadmin are available with a newly installed ISPConfig. Though login at both the link fail with correct mysql password of root user. Do we need any modification at /etc/phpmyadmin/config.inc.php or need to look at other configuration ? Please suggest. Thanks for your valuable support
phpmyadmin works out of the box on debian; what OS do you have and did you follow a Perfect Server guide to install or ?
Hi Jesse, this is ubuntu 16.04 and yes, followed perfect server guide available at howtoforge. Can log into mysql as root at console but not through phpmyadmin. Please advise
Jesse why mysql goes into mariaDB in ubuntu ? mysql -v Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 17681 Server version: 10.0.25-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04 Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Reading history-file /root/.mysql_history Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
There is an AllowRoot config setting, maybe ubuntu has that enabled by default? http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_AllowRoot
Hi Jesse, the issue fixed by following steps echo "update user set plugin='' where User='root';" | mysql -root -p mysql service mysql restart
