Hi guys, in install on ubuntu 19.10 phpmyadmin and during the configuration i get the following questions: Code: sudo dpkg-reconfigure phpmyadmin reinstall database - yes connection method for mysql - unix socket mysql database name for phpmyadmin - phpmyadmin mysql username: root@localhost pw = password webserver - apache2 name of databases administrator debian-sys-maint when i login with user root@localhost to phpmyadmin and put in my password, it is not accepted. on console i do mysql -u root -p then put my password but i get Access denied for user root@localhost what i am doing wrong? maybe someone can help me with this matter.. thanks a log guys
Try the command: cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf It should give you the root password.
Ubuntu disallows root logins with phpmyadmin now by default. If you google for that topic, you will find instructions on how to reconfigure the mysql root user to allow login with phpmyadmin, or look at recent Debian 10 or Ubuntu 18.04 perfect server guides, they contain some instructions as well to reconfigure the mysql root user.