phpmyadmin login access denied with root account.

  • I have test mysql -u root -p and use current password.It's can login mysql.
    But I login phpmyadmin use the same account password.It's will show Access Denied.
    How to fix it?

  • badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • Hello,
    I have edit /etc/imscp/pma/working/FrontEnd and /etc/imscp/pma/working/config.inc.php change $cfg['Servers'][$i]['AllowRoot'] to true.
    And run service imscp_panel restart.
    But it's still show access denied.Could I need reboot system?

  • I also edit /var/cache/imscp/packages/vendor/imscp/phpmyadmin/imscp.config.inc.php and restart imscp_panel.
    It's can login it.Please fix in next version.Thanks a lot.

  • @akong7777


    There is nothing to fix here. Usage of SQL root user has been forbidden in latest i-MSCP PhpMyAdmin package version for security reasons and also because sometime, that user is only usable by local UNIX root user (case of passwordless authentication). If you still want use that user to connect to PMA, you must in order:

    • Ensure that you have an SQL root user for localhost (root@localhost)
    • Override default PhpMyAdmin configuration file using the 10_phpmyadmin_conffile.pl listener file
    • Run i-MSCP setup script as follow:

    with version 1.2.17:

    Shell-Script
    1. # perl /var/www/imscp/engine/setup/imscp-setup -d

    with version > 1.2.17 (currently 1.2.x branch):

    Shell-Script
    1. # perl /var/www/imscp/engine/setup/imscp-reconfigure -d

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206