[Case 74793] Internal Server Error 500 - Remote MySQL for one user

[jamesterror]

Hi,

Our environment is setup whereby we have web servers, and a standalone MySQL server that we use for Remote MySQL connectivity. One user is experiencing a problem when accessing phpMyAdmin, getting the error message Error in Process Request - Error Code: 500 - Error text: Internal Server Error, please see - http://puu.sh/3ZhBs.png

This issue is only occurring for one user, we have tried the following - Cross checked the permissions with other users and chown'd and reset the permission, deleted the account and restored from a backup.

There are no errors showing for the user under /var/log/messages as well as the .err file under /var/lib/mysql/

Edit: To clarify, both servers are running WHM 11.38.2, operating MySQL 5.1

Any suggestions with re-mapping or fixing this issue would be fantastic.

Kind Regards,
James

 

[rasa]

Helo
i have similar issue on websites not phpmyadmin just after migrating databases to remote database server !

 

[cPanelMichael]

Our environment is setup whereby we have web servers, and a standalone MySQL server that we use for Remote MySQL connectivity. One user is experiencing a problem when accessing phpMyAdmin, getting the error message Error in Process Request - Error Code: 500 - Error text: Internal Server Error, please see - http://puu.sh/3ZhBs.png

Please try updating the account password via:

"WHM Home » Account Functions » Password Modification"

Ensure that "Allow MySQL password change" is selected. Note that internal case number 74793 is open to address an issue similar to what you have reported.

Thank you.

 

[jamesterror]

Please try updating the account password via:

"WHM Home » Account Functions » Password Modification"

Ensure that "Allow MySQL password change" is selected. Note that internal case number 74793 is open to address an issue similar to what you have reported.

Thank you.

Perfect! This has now worked. The user had changed the password themselves but I guess it needed root to do this?

Thanks for your help Michael.