PHPMyAdmin Permissions Change

[theywill]

CentOS 6.6
Plesk 12.0.18
64-bit

At some point, not sure when, PHPMyAdmin's (as accessed through the admin panel by clicking on a customer, manage hosting, databases, etc) permissions have changed such that I cannot view, edit or add MySQL routines/procedures. This appears to have occurred system-wide, though I have not checked every database on the server.

Is there a fix to get the permissions set so that I can make these changes again?

Best regards,
James

 

[theywill]

I did find this KB article. However, the user accounts already have the right permissions.
http://kb.odin.com/en/115749

I tried adding the privileges for a phpmyadmin* account, but that didn't work either.

Thanks for your help.

 

[IgorG]

Please look at this thread - http://talk.plesk.com/threads/phpmyadmin-on-plesk-12.331057
I hope it will help.

 

[theywill]

Hi Igor,

Indeed. Thank you for this. They key is that second screen capture. You must click on the username and set global privileges.

This is a bit of nuisance to change, but I suppose few will really need this access.

Best regards,
James