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?
phpmyadmin login access denied with root account.
-
- won't fix
- akong7777
- Thread is marked as Resolved.
-
-
See phpmyadmin root
-
-
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. -
-
edit:
/var/www/imscp/gui/public/tools/pma/config.inc.php
then:
service imscp_panel restartand read the link in #2 again.
-
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:
with version > 1.2.17 (currently 1.2.x branch):
-
-
I understood is the security reason.So,I will use this settings.Thanks a lot.