phpmyadmin password

Discussion in 'Installation/Configuration' started by Tom John, Feb 25, 2020.

  1. Tom John

    Tom John Active Member HowtoForge Supporter

    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
     
    Last edited: Feb 25, 2020
  2. nocs

    nocs New Member

    Try the command: cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf

    It should give you the root password.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page