Question phpMyAdmin prompts for pswd after cpanel>plesk migration

[GlennT]

Hello,

I've recently performed large migration from cpanel to plesk and now phpMyAdmin prompts for password on every domain user.

I tried going into Plesk DB manager and assigning database to the user and then checking: 'Use this user's credentials by default for accessing phpMyAdmin'

It doesn't work and still prompts for password.

Anyone have any suggestions on how to fix this?

thx
G

 

[IgorG]

Check that you have line

$cfg['Servers'][$i]['auth_type'] = 'config';

instead of

$cfg['Servers'][$i]['auth_type'] = 'cookie';

in phpMyAdmin config file config.inc.php

 

[GlennT]

Thanks Igor but where is this file located?

I checked /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin and see config.manyhosts.inc.php in examples directory file but this doesn't appear to be correct file.

I don't see config.inc.php in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin

Thanks
G

 

[IgorG]

I mean /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.sample.inc.php that may be renamed to /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.inc.php

 

[linuxman1]

Hello Igore,
I had this strange issue on a server after I migrated from Cpanel, phpmyadmin always asks for passwords and says,
"Enter the password to log in as the database user user"
I tried your mentioned trick without success and I can't fix manually phpmyadmin credentials for more than 200 databases!
Please help.

 

[menderes]

Hello @linuxman1,

Re-install PhpMyAdmin Extensions.You can look at this: [FIXED BUG] Database users not migrated from cPanel to Plesk

 

[linuxman1]

Hello @menderes,
I don't think it's related, I use the latest version of Plesk and extensions, also the databases users were migrated and web sites are working fine on new server, it's just phpmyadmin can't login to databases without entering passwords for those databases.
So I have to lookup the passwords of databases so I can use phpmyadmin!

 

[menderes]

Hi @linuxman1,

As I understand you are having problems with user authorization. Can you examine that?: User management — phpMyAdmin 5.1.0-dev documentation

 

[linuxman1]

Hi menderes,
I think because Plesk uses different encryption than Cpanel so it couldn't migrate Phpmyadmin credentials from cpanel, this also happened to me with FTP passwords as I had to reset it on Plesk for the same reason, I asked Plesk team for advice or any recommendation or even to verify if I am wrong or right! silence is the answer! Hello Plesk team!.